COUNTBLANK
Counts the number of blank cells within a range.
StatisticalStatistics & Analysis
What it does
Counts the number of empty cells in a range.
Syntax
COUNTBLANK(range)
Arguments
range(range) — The range to count blanks in.
Examples
Count missing values
Count empty cells in A2:A5.
FORMULA
=COUNTBLANK(A2:A5)
RESULT
1
SAMPLE DATA
| A | |
|---|---|
| 1 | Data |
| 2 | 10 |
| 3 | |
| 4 | 20 |
| 5 | Text |