COUNT
Counts cells that contain numbers.
How it’s written
COUNT(range)Example
| A | |
|---|---|
| 1 | Paid |
| 2 | 400 |
| 3 | |
| 4 | 250 |
=COUNT(A2:A4)Result: 2
Counts the two amounts and skips the empty cell.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
COUNT returning less than you expect often means some numbers are stored as text.
Practice it properly
Counting what’s there gives you real tasks, with your formulas tested on data you haven’t seen.