Counts the empty cells in the specified ranges of cells.
Syntax
 Copy Code
|
|---|
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
Copy Code
|
|---|
=COUNTBLANK(A1:C5) |
See Also
Function Reference
COUNT Function
COUNTA Function
COUNTIF Function