The Excel COUNTBLANK Function

Related Functions:
COUNT
COUNTA

Basic Description

The Excel Countblank function returns the number of blank cells in a supplied range.

The syntax of the function is:

COUNTBLANK( range )

Where the range argument specifies the range of cells in which you want to count blank cells.

Note that, if a cell contains an empty text string or a formula that returns an empty text string, this cell is counted as a blank by the Countblank function.


Countblank Function Examples

In the spreadsheets below, the Excel Countblank function is used to calculate the number of blank cells in two different cell ranges.

Example 1:
Example of the Excel Countblank Function
- Gives the result 3.
Example 2:
Example of the Excel Countblank Function
- Gives the result 9.

Further examples of the Excel Countblank function are provided on the Microsoft Office website.