COUNT Function
Counts how many cells contain numbers.
Category
Statistical
Available in
All versions, Microsoft 365
Returns
A whole number
Overview
COUNT counts the cells that hold numbers — including dates, times and zeros. Text, TRUE/FALSE, errors and empty cells aren't counted.
To count every non-empty cell, use COUNTA; to count empty ones, COUNTBLANK.
Syntax
=COUNT(value1, [value2], …)
Arguments
| Argument | Required? | What it does |
|---|---|---|
| value1 | Yes | A value, cell or range. |
| value2, … | No | Up to 255 more values, cells or ranges. |
Examples
Example 1 — How many people have a score?
Only real numbers count — "absent", "pending" and the blank don't.
D2fx=COUNT(B2:B8)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Score | Scores | |
| 2 | Ana | 82 | 4 | |
| 3 | Ben | absent | ||
| 4 | Cy | 91 | ||
| 5 | Di | |||
| 6 | Ed | 77 | ||
| 7 | Fay | 0 | ||
| 8 | Gus | pending |
=COUNT(B2:B8) Explain
Common mistakes
- Numbers stored as text aren't counted. Imported "numbers" that are really text give a lower count than expected. Convert them with VALUE.
Notes
- Related functions: COUNTA, COUNTBLANK, COUNTIF, COUNTIFS.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.