Hi,

this might also work for you

=SUMPRODUCT((B1:B100=A1)*(C1:C100=A2)*OR(E1=A3:A5) *(D1:D100))

Adjust as needed.

If this helps please click the Yes button

Cheers,
Shane Devenshire

"JustBreathe" wrote:

in the 3rd array of my sumproduct formula, i'd like to have it look for more
then one option. what is the correct way to write this forumla???

=SUMPRODUCT(--(COLUMN1=A1),--(COLUMN2=A2),--('BW COLUMN3=A3 or A4 or
A5),(COLUMN4))



tia!!