Excel function COUNTBLANK

The COUNTBLANK function returns the number of blank cells.

Select the COUNTBLANK function and then enter the range of cells from which you would like to return the total number of empty cells.

countblank function - countblank

Click on OK, and the result will be displayed.

countblank - countblank