Calculate the sum if two different conditions
Closed
jyotishdev_g
Posts
1
Registration date
Tuesday 30 June 2009
Status
Member
Last seen
1 July 2009
-
1 Jul 2009 à 13:58
Mahesh - 8 Oct 2009 à 00:37
Mahesh - 8 Oct 2009 à 00:37
Related:
- Calculate the sum if two different conditions
- Formula to calculate vat in excel - Guide
- Vba calculate - Guide
- How to calculate oz to ml - Excel Forum
- Calculate mtu - Guide
- Conditional formatting if cell contains text - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
1 Jul 2009 à 20:15
1 Jul 2009 à 20:15
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.
2 Jul 2009 à 12:08
8 Oct 2009 à 00:37