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...
Even somewhat shorter than from OliverScheurich :
=SUMPRODUCT(SUBTOTAL(3,OFFSET($G$2,ROW($G$2:$G$286)-ROW($G$2),0)),--($G$2:$G$286<=6))
