Using COUNTBLANK to count number of blank cells

This formula counts the number of empty cells in a specified range of cells. It’s a very straight-forward formula. This formula is one of the many Information formulas available in Excel.

Information formulas serve the purpose of returning all sorts of information regarding a table or a set of cells.

COUNTBLANK(range)

RANGE is the range of cells to be counted. It could involve multiple rows and columns. Some examples are A2:C6 or A2:A50.

For instance, if range of cells A2:C6 has 2 blank cells. The outcome of COUNTBLANK(A2:C6) is 2.