Match Index multiple criteria

[damondole]

Trying to get the result in C8 and D8 to read 480 and 480 respectively using the following formula:

=IF(OR(AND(G1=A8,B1="BAN"),AND(G2=A8,B2="BAN"),AND(G3=A8,B3="BAN"),AND(G4=A8,B4="BAN")),INDEX(C1:C4,MATCH(A8,G1:G4,0)),"")

The result does not sum both 240 listed in C1&C2, C3&C4 respectively.. Need help

Column1	Column2	Column3	Column4	Column5	Column6	Column7
LPO53D	BAN	240				10
LPO53D	BAN	240				10
EPO53C	ORG	240				10
EPO53C	ORG	240				10
10		240	240

<!--StartFragment--> <colgroup><col width="100" span="7" style="width:75pt"> </colgroup><tbody>
<!--EndFragment--></tbody>

<attachment></attachment>

 

[jtakw]

Hi,

If you have SUMIFS:

Excel 2010
	A	B	C	D	E	F	G
1	LPO53D	BAN	240				10
2	LPO53D	BAN	240				10
3	EPO53C	ORG	240				10
4	EPO53C	ORG	240				10
5
6
7
8	10		480	480
Sheet3

Cell Formulas
Range	Formula
C8	=SUMIFS($C1:$C4,$G1:$G4,$A8,$B1:$B4,"BAN")
D8	=SUMIFS($C1:$C4,$G1:$G4,$A8,$B1:$B4,"ORG")

 

[steve the fish]

Hi. Do you mean this?

=SUMIFS(C1:C4,B1:B4,"BAN",G1:G4,A8)

 

[damondole]

Hi. Do you mean this?

=SUMIFS(C1:C4,B1:B4,"BAN",G1:G4,A8)

Thank you.. That worked!!!