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:

1. =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:

1. The corresponding value in column C equals the value in cell R2
2. The corresponding value in column E equals "Mat"
3. The corresponding value in column F equals "AT1"
4. The corresponding value in column K is less than or equal to 35