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

Antonio Gonzalez

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"

JCluff

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

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