Hi Mifty,
Yes, you can definitely use
less than or equal to with the
SUMPRODUCT function. To modify your formula to count values less than or equal to 35, you can use the
less than or equal to operator (<=) instead of the
equal to operator (=) in the last criteria of your formula.
Here's the modified formula:
- =SUMPRODUCT(($C$2:$C$16010=R2)*($E$2:$E$16010="Mat ")*($F$2:$F$16010="AT1")*($K$2:$K$16010<=35))
This formula will count all the values in column K that meet the following criteria:
- The corresponding value in column C equals the value in cell R2
- The corresponding value in column E equals "Mat"
- The corresponding value in column F equals "AT1"
- The corresponding value in column K is less than or equal to 35