Using SUMIFS to match two criteria and sum array

[iamanexcelnoob]

hey all.

quick and probably easy (for you guys) question.

i have a data pull on one tab and an analysis tab on another.

i want to extract said data by honing in on two specific criteria, located in Column A and Column B - and denoted as such in my analysis tab and summing the resulting 3 columns (D,E,F) if the conditions are met.

i'm sure there is a way with SUMIFS, but i just keep getting #VALUE! messages.

thanks!

 

[63falcondude]

Try something along the lines of this

Excel 2010
	A	B	C	D	E	F	G
1	Yes	Green	1	2	3
2	Yes	Blue	4	5	6		15
3	Yes	Red	7	8	9
Sheet1

Cell Formulas
Range	Formula
G2	=SUMIFS(C:C,A:A,"Yes",B:B,"Blue")+SUMIFS(D:D,A:A,"Yes",B:B,"Blue")+SUMIFS(E:E,A:A,"Yes",B:B,"Blue")

 

[Aladin Akyurek]

Control+shift+enter, not just enter:

=SUM(IF($A$2:$A$100=K2,IF($B$2:$B$100=L2,$D$2:$F$100)))

where K2:L2 houses the conditions which must hold for columns A and B.

 

[iamanexcelnoob]

Control+shift+enter, not just enter:

=SUM(IF($A$2:$A$100=K2,IF($B$2:$B$100=L2,$D$2:$F$100)))

where K2:L2 houses the conditions which must hold for columns A and B.

wowie! thank you!!

 

[Aladin Akyurek]

wowie! thank you!!

You are welcome.