Calculate the sum if two different conditions

Closed
Report
Posts
1
Registration date
Tuesday June 30, 2009
Status
Member
Last seen
July 1, 2009
-
 Mahesh -
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 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Thanx Yar...Good one....