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