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 90 days from date in excel  Guide
 How to calculate position in excel  Office Software Forum
 Excel conditional formatting if another cell contains specific text ✓  Excel Forum
 Sum if greater than and less than cell value ✓  Excel Forum
 Conditional formatting if cell contains text  Excel Forum
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