SUMPRODUCT Can I use less than or equal to with this function
Su
...........*($K$2:$K$16010<=35))
However, if there are any empty cells in that range they will meet the
condition of <=35. If you don't want the empty cells counted then you need
to add another test:
...........*($K$2:$K$16010<=35)*($K$2:$K$16010<"" ))
--
Biff
Microsoft Excel MVP
"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
|