COUNTBLANK

Syntax:

COUNTBLANK ( cell-range )

Description: Counts the number of cells in a specified range of cells, which are empty. A cell containing a formula that returns an empty string is counted, whereas a cell containing a zero value is not.

Arguments:

Name

Type

Description

cell-range

reference

Designates the range of cells to be inspected.

Return Type and Value: number – The number of empty cells in the range specified.

example: