--('BW COLUMN3=A3 or A4 or A5)

Try this:

--(ISNUMBER(MATCH('BW COLUMN3,A3:A5,0)))



--
Biff
Microsoft Excel MVP


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