Skip to main content

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:

ArgumentDescription
rangeA 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