EXCEL COUNTBLANK FUNCTION

The COUNTBLANK is an Excel function to count blank cells in a range or an array.

Syntax:

=COUNTBLANK(range)

Arguments or Parameters:

range: a cell of range to count blank cells

Objective: Find the count of blank cells in the range B3:B20.

Step 1:

Type = sign in cell E4
Type COUNTBLANK Function

Step 2:

Select range B3:B20
Type “)”
Press Enter

Conclusion: The COUNTBLANK function has counted 2 blank cells.