How to Use COUNTBLANK Function

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.

Leave a Reply