COUNTBLANK Function

The COUNTBLANK function is one of the statistical functions. It is used to analyze the range of cells and return the number of the empty cells.

Syntax

COUNTBLANK(range)

The COUNTBLANK function has the following argument:

Argument Description
range A range of cells you wish to count.

Notes

How to apply the COUNTBLANK function.

Examples

The figure below displays the result returned by the COUNTBLANK function.

COUNTBLANK Function