Help with SUMPRODUCT formula - Include 0 and 1 but not 10

New Contributor

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?


6 Replies



This returns the expected result if i correctly understand what you want to do.




Even somewhat shorter than from @Quadruple_Pawn :



@Quadruple_Pawn This works perfectly, thank you!
@dscheikey This is awesome, shorter is great, thank you!



A 365 solution.


Swap out 'numbers' with your range.



@Patrick2788 This looks very interesting, I will need to review this as I am not familiar. Thank you!