sumproduct not working
Another way is
=SUMPRODUCT(--ISNUMBER(MATCH$(F$3:$F$1500,{5,6,7},0)),--($L$3:$L$15000),$M$3:$M$1500)
This syntax allows you to replace {5,6,7} with a range of cells containing
your possible match values, e.g., especially useful if there are large
numbers of possible or if they're variable
=SUMPRODUCT(--ISNUMBER(MATCH$(F$3:$F$1500,X1:X3,0)),--($L$3:$L$15000),$M$3:$M$1500)
"Ron Coderre" wrote:
I think in this situation you'd need to use this variation of the SUMPRODUCT
function:
=SUMPRODUCT(($F$3:$F$1500={5,6,7})*($L$3:$L$15000 )*$M$3:$M$1500)
Note the curly braces around the 5,6,7 array
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Tester" wrote:
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
|