<< Click to Display Table of Contents >> COUNTBLANK (number of empty cells)

Syntax:

COUNTBLANK(range)

Description:

This determines how many cells in a range 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