Purpose
Count cells that are blank
Return value
A number representing blank cells
Syntax
=COUNTBLANK (range)
Arguments
- range – The range in which to count blank cells.
Usage notes
Use the COUNTBLANK function to count blank cells in a range. For example, COUNTBLANK(A1:A10) will count the number of blank cells in the range A1:A10.
COUNTBLANK counts the number of cells in the range that don’t contain any value and returns this number as the result. Cells that contain, text, numbers, errors, etc. are not counted.
Cells that contain formulas that return empty text (“”) are considered blank and will be counted.
Cells that contain zero are considered not blank and will not be counted.