The COUNT function in Excel
COUNT tells you how many cells in a range contain numbers.
What COUNT does
It counts numbers only. Text, blank cells and errors are not counted. That makes it a quick way to spot missing data: compare the count with the number of rows you expect. Dates are stored as numbers, so they are counted too.
Syntax
=COUNT(value1, [value2], ...)
- value1
- The first cell or range to check.
- value2, ...
- Optional. More cells or ranges.
Worked example
| A | B | |
|---|---|---|
| 1 | Reading | Value |
| 2 | R1 | 12 |
| 3 | R2 | n/a |
| 4 | R3 | 30 |
| 5 | R4 | 25 |
| 6 | R5 | n/a |
| 7 | Numbers | 3 |
Five cells hold something, but only three are numbers. The two n/a entries are text, so COUNT skips them.
Now you try
A fresh exercise every time. Press Another exercise as often as you like.
Where you will use it
Data cleanup
Check how many entries in a column are really numeric.
HR
Count how many timesheets have hours filled in.
Sales & Ops
Count how many readings or orders came in.
Common mistakes
- Using COUNT on a column of names and getting 0. Use COUNTA to count every non-empty cell, whatever it holds.
- Numbers stored as text are not counted, so the result is lower than you expect.
- Forgetting that dates count as numbers, which can make a text-and-date column look bigger than it is.
The COUNT course
- 1Count the numbersFree practice belowPractise
- 2Count text entries with COUNTAComing soon
- 3Count blanksComing soon
- 4Spot missing dataComing soon
- 5Count unique entriesComing soon
Common questions
What is the difference between COUNT and COUNTA?
COUNT counts only numbers. COUNTA counts every cell that is not empty, whether it holds a number, text or a date.
Does COUNT include zeros?
Yes. A zero is a number, so it is counted.