COUNTBLANK

Counts the empty cells in the specified ranges of cells.

Syntax

COUNTBLANK( [Reference value1], [Reference value2], ... ) → Integer

Parameters

value1
value2
…

Zero or more cell references to include in the counting.

Remarks

Counts the number of non-blank values in the cell or cells in the specified list. A cell is considered blank if it does not contain any data, that is if ISBLANK for this cell returns TRUE. Cells containing zeros, or empty strings are not blank. Errors values are not counted and do not cause the function to return an error (that is, this function does not propagate errors).

If there are no arguments provided, the function returns zero.

Example

Formula

=COUNTBLANK(A1:C5)

See Also

Function Reference
COUNT Function
COUNTA Function
COUNTIF Function