COUNTBLANK Function in Excel – Count the number of blank cells

COUNTBLANK Function in Excel returns the number of blank cells. In other words, COUNTBLANK Function count the cells only if the cell have no values in it.

Syntax of COUNTBLANK Function in Excel:

COUNTBLANK( Range )

Argument range is the range of cells for which you have to count the blank cells.

 

Example of COUNTBLANK Function in Excel

Formula

COUNTBLANK Function in Excel 1

  • Only empty cells are counted by the COUNTBLANK function.
  • First formula calculates the number of blanks in cell range A2:A7 which has 1 blank cell
  • Second formula calculates the number of blanks in cell range A2:A8 which has 2 blank cells

So the result will be

Result

COUNTBLANK Function in Excel 2

previous COUNTBLANK Function in Excel                                                                                                                next COUNTBLANK Function in Excel