COUNTBLANK (number of blank cells)

<< Click to Display Table of Contents >>

COUNTBLANK (number of blank cells)

Syntax:

COUNTBLANK(Range)

Description:

Counts the number of cells in a cell range that are empty.

Example:

If the cells A1:A3 contain 42, "Test" and TRUE and cell A4 is empty. The following applies:

COUNTBLANK(A1:A4) returns 1

See also:

ISBLANK, COUNT