Navigation: Formulas and functions > Functions from A to Z >
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
