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...