The COUNTBLANK function provides us with a way to count the number of cells within a given cell range that are blank.
This is the syntax of the function:
COUNTBLANK(range)range : They are the cell references or cell ranges within which you want to count the blank cells.
Empty cells (“”) are counted as blank, but zero value cells are not counted.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the COUNTBLANK function:
Use the countblank function in the cell B1 to count the blank cells in the cell range A1:A400.