The COUNTBLANK function counts the number of empty cells.
Formula:
= COUNTBLANK(range)
Explanations:
The range is required, which is the range to count the empty cells.
Cautions:
Cells with zeros or spaces are not counted.
Example 1: Count the number of blank cells in the data range A2:A6
=COUNTBLANK(A2:A6)
To count the number of blank cells in the data range A2:A6, the result returns 1.
Example 2: Count the number of blank cells in the data range C2:C6
=COUNTBLANK(C2:C6)
To count the number of blank cells in the data range C2:C6, the result returns 0.
