Excel + Google Sheets · COUNTBLANK
Find missing data fast
Counts the empty cells in a range.
The formula
=COUNTBLANK(B2:B6)What each part means
B2:B6Where to look for blanks
Example
| A | B | |
|---|---|---|
| 1 | Client | Phone |
| 2 | Acme | 555-0101 |
| 3 | Bolt | |
| 4 | Cora | 555-0199 |
| 5 | Dyno | |
| 6 | Echo | 555-0142 |
| 7 | Missing |
| A | B | |
|---|---|---|
| 1 | Client | Phone |
| 2 | Acme | 555-0101 |
| 3 | Bolt | |
| 4 | Cora | 555-0199 |
| 5 | Dyno | |
| 6 | Echo | 555-0142 |
| 7 | Missing | 2 |
Step by step
- Click cell B7.
- Type the formula:
=COUNTBLANK(B2:B6) - Press Enter.
- Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.
Where it works
- Every version of Excel
- Google Sheets
- Excel for the web (free)
The same formula in other languages
- English COUNTBLANK
- Español CONTAR.BLANCO
- Português CONTAR.VAZIO