What formula can I use to count both the blank spaces of a column and the data from another column?

Options

I want to count the blank spaces of a column titled "completed" where the cells are either blank or have "yes" on them, while at the same time counting the cells of another column in which the cells are blank, "enrolled" and "waitlisted"

Answers

  • JCluff
    JCluff ✭✭✭✭
    Options

    You'll want to use COUNTIF with an OR statement. You'll need to correct the ranges, but it will look like this:

    =COUNTIF(Range1:Range1, OR(ISBLANK(@cell), @cell = "yes")) + COUNTIF(Range2:Range2, OR(ISBLANK(@cell),@cell="enrolled",@cell="waitlisted"))

    Make sure that you designate the exact range you want to count otherwise the formula will read all blank cells under your data.

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    Hey @Antonio Gonzalez

    As an alternative to the formula above, the COUNTIFS (plural) function has additional versatility in not being limited to only evaluating a single criteria. The COUNTIFS can evaluate any number of criteria- from one to whatever. This means the two added COUNTIF functions above can be combined into a single statement.

    =COUNTIFS(Range1:Range1, OR(ISBLANK(@cell), @cell = "yes"), Range2:Range2, OR(ISBLANK(@cell),@cell="enrolled",@cell="waitlisted"))

    Kelly

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!