COUNT - Count numeric entries
Find how many scores, amounts, or measurements have been entered without mistaking text or missing values for numbers.
By the end, you can
- Count numeric cells with COUNT.
- Distinguish zero, text, and blanks.
- Use a count to check a report's coverage.
Before you start: Read cell ranges such as B2:B6. AVERAGE explains why the number of numeric values matters.
In this lesson
Count results, not every row
A recruitment coordinator has five candidates but not every assessment is finished. COUNT tells you how many numeric scores are present. It returns a quantity of entries, not their sum or their mean. Use it for scored assessments, entered invoice amounts, or recorded measurements.
Syntax and arguments
=COUNT(value1, [value2], ...)Supply at least one value, cell, or range. Brackets and dots mark optional arguments; do not type them into the formula.
| Argument | Purpose | Example |
|---|---|---|
value1Required | The first range or value to inspect for numbers. | B2:B6 |
value2, …Optional | Additional cells, ranges, or values; up to 255 arguments in total. | D2:D6 |
Recruitment: how many assessments are scored?
3| A | B | C | D | |
|---|---|---|---|---|
| 1 | Candidate | Score | Scored | |
| 2 | Anika | 78 | 3 | |
| 3 | Dev | Pending | ||
| 4 | Meera | 0 | ||
| 5 | Rahul | |||
| 6 | Zoya | 92 |
=COUNT(B2:B6)78, 0, and 92 are numbers. Pending and the blank cell do not count.
Count selected cells or additional inputs
=COUNT(B2,B6)Count Anika and Zoya without including the rows between them.
=COUNT(B2:B6,100)The numeric constant adds one more entry; it does not add 100 to the result.
To count two separate reporting periods, supply both ranges to COUNT. Keep them non-overlapping or a repeated numeric cell contributes twice. Use COUNTIF for a pass threshold rather than trying to make COUNT apply a condition.
What counts as numeric?
- Numeric zero and negative numbers count. Decimal amounts also count once each.
- In referenced cells, text, blanks, logical values, and errors are ignored. A number imported as text is not counted.
- Excel dates and times stored as numeric serial values count; date-looking text does not.
- Direct arguments have different coercion rules: Excel can count numeric text and logical values typed into the argument list. Prefer clean numeric cells in business reports.
Common mistakes and practical checks
Exclude the result cell from the range to avoid a circular reference. After an import, compare the numeric count with the expected number of entries and check unexpected gaps.
Check your understanding
Choose an answer for instant feedback. You can try again; answers stay only on this page.