Forum Discussion
Help with SUMPRODUCT formula - Include 0 and 1 but not 10
Hello! I have a column that contains numbers 0 through 10. I'd like to count (with filter) cells that are <=6. I have this formula, but it is including cells with 10. How do I exclude 10? =SUMPRODUC...
A 365 solution.
Swap out 'numbers' with your range.
=REDUCE(0,numbers,LAMBDA(a,v,IF(AND(SUBTOTAL(2,v)=1,v<=6),a+1,a)))
Patrick2788 This looks very interesting, I will need to review this as I am not familiar. Thank you!