You can't use OR like that.

--
Biff
Microsoft Excel MVP


"Shane Devenshire" wrote in
message ...
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!!