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
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 June 14, 2009 Status Contributor Last seen August 7, 2021 811
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.
7
thanks venky
0
Thanx Yar...Good one....
0