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