i am trying to count all cells that are greater then 0 but only on certain cells, not the whole column

as shown in print screen

i would also like to have a formula that shows cells in column that are greater than 0 but less than 100

what is the right formula?

thanks in advance


  • BullandKhmer
    BullandKhmer ✭✭✭✭✭

    Is it only parent rows that you dont want counted?

    If so then you could add a helper column with a column formula


    then use a countifs formula


    Then for between 0 & 100


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!