Module 11
4 min
COUNT, COUNTA, COUNTBLANK
Count cells with numbers, text, or empty cells
COUNT, COUNTA, COUNTBLANK
Want to count how many cells have data? These 3 functions help you!
COUNT
Counts cells with numbers only.
=COUNT(range)
| A |
|---|
| 10 |
| Hello |
| 20 |
| 30 |
5 rows
=COUNT(A1:A5) → 3
Only counts 10, 20, 30 (numbers). Ignores "Hello" and empty cell.
COUNTA
Counts cells with any data (numbers + text).
=COUNTA(range)
| A |
|---|
| 10 |
| Hello |
| 20 |
| 30 |
5 rows
=COUNTA(A1:A5) → 4
Counts 10, Hello, 20, 30. Only skips empty cell.
COUNTBLANK
Counts empty cells only.
=COUNTBLANK(range)
| A |
|---|
| 10 |
| Hello |
| 30 |
5 rows
=COUNTBLANK(A1:A5) → 2
Counts only the 2 empty cells.
Quick Comparison
| Function | What It Counts | Example Result |
|---|---|---|
| COUNT | Numbers only | 3 |
| COUNTA | Any data (numbers + text) | 4 |
| COUNTBLANK | Empty cells | 2 |
3 rows
Real Life Examples
Count students with scores:
=COUNT(B2:B50)
Count filled forms:
=COUNTA(A2:A100)
Count missing entries:
=COUNTBLANK(C2:C100)
Summary
- COUNT → numbers only
- COUNTA → any data (A = All)
- COUNTBLANK → empty cells
- All use same format:
=FUNCTION(range)