Count empty cells with COUNTBLANK
In E2, use COUNTBLANK to count how many phone numbers are missing in B2:B7.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Name | Phone | ||||
| 2 | Anna | 51234567 | Missing | |||
| 3 | Ben | |||||
| 4 | Cara | 40112233 | ||||
| 5 | Dan | |||||
| 6 | Eva | |||||
| 7 | Finn | 22334455 | ||||
| 8 |
Need help?
Why this works
COUNTBLANK counts the empty cells in a range. With COUNTA you could also write =ROWS(B2:B7)-COUNTA(B2:B7), but COUNTBLANK says what you mean.
Common mistake: Counting the filled-in cells with COUNTA and forgetting to subtract them from the total. COUNTBLANK counts the empty ones directly.
The answer
- E2
=COUNTBLANK(B2:B7)
+10 points