SUMPRODUCT Can I use less than or equal to with this function
You're welcome. However, please make note of T. Valko's point about column
K values that are either empty.
--
"Mifty" wrote in message
...
Thank you Paul :-)
Cheers
--
Mifty
"PCLIVE" wrote:
Try this:
=SUMPRODUCT(($C$2:$C$16010=R2)*($E$2:$E$16010="Mat ")*($F$2:$F$16010="AT1")*($K$2:$K$16010<=35))
I prefer this method. Though the result is the same.
=SUMPRODUCT(--($C$2:$C$16010=R2),--($E$2:$E$16010="Mat"),--($F$2:$F$16010="AT1"),--($K$2:$K$16010<=35))
HTH,
Paul
--
"Mifty" wrote in message
...
Hi there,
I'm using this formula but can I amend it so that it counts less than
or
equal to 35 rather thatn just 35?
=SUMPRODUCT(($C$2:$C$16010=R2)*($E$2:$E$16010="Mat ")*($F$2:$F$16010="AT1")*($K$2:$K$16010=35))
Grateful for any help
Cheers
--
Mifty
|