AND conditions before summing up

  • Thread starter Thread starter Ginger
  • Start date Start date
G

Ginger

Hi,

Let say my data are as follows:-
A B C D
100 6 T 10'
200 7 E 15
300 6 D 10
400 5 F 20
500 6 T 11'

Question:-
I will sum up the numbers from Col D if the number in Col
B is "6" AND the text in Col C is "T". How do I come up
with this formula? Does sumif works here? If yes, how?
In this case, my answer should be 10 + 11 = 21.

Hope somebody can help me out here.

Thanks.
 
Ginger said:
Hi,

Let say my data are as follows:-
A B C D
100 6 T 10'
200 7 E 15
300 6 D 10
400 5 F 20
500 6 T 11'

Question:-
I will sum up the numbers from Col D if the number in Col
B is "6" AND the text in Col C is "T". How do I come up
with this formula? Does sumif works here? If yes, how?
In this case, my answer should be 10 + 11 = 21.

Hope somebody can help me out here.

Thanks.
Click to expand...

SUMIF can only manage one condition. For more you need SUMPRODUCT.
=SUMPRODUCT((B1:B5=6)*(C1:C5="T"),D1:D5)
 
Back
Top