Another Sumif problem

[Jessejames]

A B C D
E
1 col tot subtot1 subtot2 DISC
2 black 12 1 11 AA
3 white 14 2 12 BB
4 blue 16 3 13 CC
5 blue 18 4 14D DD

QUERY1: (COLUMN A TO D ONLY, COLUMN E WILL BE USED ON QUERY2)
8 blue 34

query 1 states that if i type black (A8) the response of the B8 will be 34
using the formula below ( 16+18)
=SUMIF(A2:A5,A8,B2:B5)

query 1 has no problem
and query 2 will follow.....

but i added one column E (disc)

and as we can see i need to get only the value for column E with CC disc
ONLY, it should be 16 only. please help and put the exact formula. tnx

=)

==================

 

[Ms-Exl-Learner]

Try this…

Excel 2003:-
=SUMPRODUCT((A2:A5=A8)*(E2:E5="CC"),B2:B5)

Excel 2007:-
=SUMIFS(B2:B5,A2:A5,A8,E2:E5,"CC")

In your example you have mentioned the A8 cell value as Black but I hope
that it should be Blue.

Remember to Click Yes, if this post helps!