Calculate the sum if two different conditions
Closed
jyotishdev_g
Posts
1
Registration date
Tuesday June 30, 2009
Status
Member
Last seen
July 1, 2009
-
Jul 1, 2009 at 01:58 PM
Mahesh - Oct 8, 2009 at 12:37 AM
Mahesh - Oct 8, 2009 at 12:37 AM
Related:
- Calculate the sum if two different conditions
- How to calculate in spreadsheet - Guide
- How to calculate vat in excel - Guide
- How to calculate position in excel - Office Software Forum
- How to calculate percentage of marks of 6 subjects - Excel Forum
- How to calculate 90 days from date in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 1, 2009 at 08:15 PM
Jul 1, 2009 at 08:15 PM
in an empty cell type this formula and see
=SUMPRODUCT(($A$1:$A$5=2)*($B$1:$B$5="a")*($C$1:$C$5))
modify the formula to suit you.
=SUMPRODUCT(($A$1:$A$5=2)*($B$1:$B$5="a")*($C$1:$C$5))
modify the formula to suit you.
Jul 2, 2009 at 12:08 PM
Oct 8, 2009 at 12:37 AM