Finding Empty Cells With COUNTBLANK

Sometimes the useful question isn't "how many cells are filled?" but "how many are empty?"

Maybe you want to know how many survey questions were skipped, or how many days have no sales logged yet.

The COUNTBLANK function answers this directly: it counts the empty cells in a range. Let's see how it works.

COUNTBLANK returns the number of empty cells in a single range.

Its shape is:

• =COUNTBLANK(range)

Unlike COUNT and COUNTA, COUNTBLANK takes just one range. It looks inside that range and tallies the cells with nothing in them.