COUNTBLANK
The COUNTBLANK function returns the number of empty cells in a given range.
This can be useful when you need to find out how many cells do not contain data.
Syntax
COUNTBLANK(range)
| Argument | Description | Permitted values |
|---|---|---|
| range | The range in which the number of empty cells must be counted | Any range of cells |
Example of use
Counting empty cells in a single range
If you have data in the range A1:A10 and want to know how many cells are empty:
=COUNTBLANK(A1:A10)
The formula counts the number of empty cells in the range A1:A10.
Notes
The COUNTBLANK function ignores cells with errors and cells containing spaces.