The COUNTBLANK function
Counts the empty cells in a range. A formula that returns "" also counts as empty.
Syntax
COUNTBLANK(range)- range
- The cells to check.
Examples
C1=COUNTBLANK(A2:A6)
| A | B | C | |
|---|---|---|---|
| 1 | Units | 1 | |
| 2 | 4 | ||
| 3 | n/a | ||
| 4 | 7 | ||
| 5 | |||
| 6 | 2 |
C1=COUNTBLANK(A1:A8)
| A | B | C | |
|---|---|---|---|
| 1 | Units | 3 | |
| 2 | 4 | ||
| 3 | n/a | ||
| 4 | 7 | ||
| 5 | |||
| 6 | 2 |