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
- 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