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
Hello,
If in column a:a if have numbers 1 to 5 and in column b:b i have a and b randomly and finally in cloumn c:c, i have different time say, 12min, 20 min etc, then In sheet two I want the sum of all the time if in cell a1 it is 2 and cell b1 it is a and like wise. Basically if
A B C
1 b 12
2 a 10
2 a 05
4 b 04
5 b 15

what i want is a formula that will calculate 10 and 05 and give the result as 15

1 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
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.
thanks venky
Thanx Yar...Good one....