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