Sumif with 3 criteria

[Hlatigo]

I want to sum a column that may move based on 3 criteria.

This worked great with two crieteria

=(SUMIF($C$8:$C$223,"EOD - 1",INDEX($F$8:$AB$223,0,MATCH($A286,$F$6:W$6,0)+0)))

this is what i tried to do but get ZERO...and i think i am missing one more variable.

=(SUMIF($B$8:$B$223,OR($B$8:$B$223="Paper",$B$8:$B$223="Physical"),INDEX($F$8:$AB$223,0,MATCH($A289,$F$6:W$6,0)+0)))

So here are the details.
~I need to sum a column that has a title of "FUELS" which is on $F$6:W$6
~the table is $F$8:$AB$223
~the second variable is on column A and I am search on current month "APR-09" $A8:$A223
~the third criteria is in column B and I want to sum the two rows that has the term "Paper' and Physcial.$B8:$B223

So basically, Sum the two rows that have paper in one and physical in the other that fall under "APR-09" and the data falls under the FUEL coulmn

Hope this makes sense

 

[barry houdini]

Try

=SUMPRODUCT(--($B$8:$B$223="APR-09"),--ISNUMBER(MATCH($B$8:$B$223,{"Paper","Physical"},0)),INDEX($F$8:$W$223,0,MATCH($A289,$F$6:W$6,0)))

I'm assuming that column A has text values, not dates, and all rows in column A are populated

 

[Hlatigo]

If I were smarter...i would have shown what the worksheet looked like...here is a small cut out. thanks for your desire to help.

I changed your formula up a little

=SUMPRODUCT(--($A$8:$A$223=AH92),--ISNUMBER(MATCH($B$8:$B$223,{"Paper","Physical"},0)),INDEX($D$8:$Q$223,0,MATCH($A289,$D$6:Q$6,0)))



******** language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js">*********>

kkkkkkk.xls
	A	B	C	D	E	F	G
6	RiskMonth			FUEL		GASOILGR
7				OpenQuantity	MTM	OpenQuantity	MTM
8	Feb-08	Paper	EOD-1	0.00
9			EOD-2	0
10			Change	0	0	0	0
11		Physical	EOD-1	0	0	0	0
12			EOD-2	0	0	0	$0
13			Change	0	0	0	0
14	Mar-08	Paper	EOD-1	0
15			EOD-2	0
16			Change	0	0	0	$0
17		Physical	EOD-1	0	0	0	0
18			EOD-2	0	0	0	0
19			Change	0	0	0	0
Data