The Excel Countblank function returns the number of blank cells in a supplied range.
The syntax of the function is:
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.
In the spreadsheets below, the Excel Countblank function is used to calculate the number of blank cells in two different cell ranges.
|- Gives the result 3.|
|- Gives the result 9.|
Further examples of the Excel Countblank function are provided on the Microsoft Office website.