COUNTBLANK in Excel

 COUNTBLANK formula 

COUNTBLANK function is used to count blank values in the range.(Note: Only Space in a cell will not be considered as a blank cell).

Example - 1

=COUNTBLANK(A1:A5)

Result = 2 

This will calculate the number of blank cell in Range. See Image below