sumproduct not working
=SUMPRODUCT((OR($F$3:$F$1500={5,6,7}))*($L$3:$L$15 000)*$M$3:$M$1500)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Tester" wrote in message
...
Hi this is my formula
=SUMPRODUCT(--($F$3:$F$1500=(OR(5,6,7))),--($L$3:$L$15000),$M$3:$M$1500)
but it returns zero value and i'm guessing its the OR function, but how can
I work around this please?
TIA
Chris
|