=SUMPRODUCT(ISNUMBER($F$3:$F$1500)*($F$3:$F$1500={ 5,6,7})*($L$3:$L$15000)*($M$3:$M$1500))


"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