Excel COUNTBLANK Function
Summary
The Excel COUNTBLANK function returns a count of empty cells in a range. Cells that contain text, numbers, errors, etc. are not counted. Formulas that return empty text are counted.
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, where the word blank means empty. For example, COUNTBLANK(A1:A10) will count the number of blank cells in the range A1:A10.
- Cells that contain text, numbers, errors, etc. are not counted.
- 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.