COUNT counts the number of cells in a range or list that contain numeric values. It ignores text, blanks, logical values, and error values, giving you a quick tally of numbers.
=COUNT(value1, [value2], …)What does COUNT do?
The COUNT function is one of Excel's simplest statistical tools. It looks at the cells you specify and returns how many of them contain numbers. That is all it does, but that simplicity makes it fast and reliable for everyday reporting.
Why does it matter? Because many business decisions depend on knowing how many numeric entries you have: how many sales were recorded, how many students submitted scores, how many invoices have amounts. COUNT gives you that number without sorting, filtering, or manual counting.
Imagine you receive a weekly sales sheet with dozens of rows. Some rows have text notes, some are blank, and only some contain actual sales figures. Instead of scrolling and counting, you point COUNT at the sales column and get an instant total of numeric entries. That is the kind of small time-saver COUNT delivers every day.
When to use COUNT
- Counting how many sales transactions have a numeric amount.
- Checking how many students have a numeric test score.
- Tallying how many invoices include a numeric total.
- Verifying how many rows in a survey contain numeric responses.
- Counting numeric entries in a column before running averages or sums.
- Quickly checking data completeness in a spreadsheet.
COUNT syntax
=COUNT(value1, [value2], …)| Argument | Required? | What to enter |
|---|---|---|
value1 | Required | The first item, cell reference, or range to count. It can be a number, a cell containing a number, or a range of cells. |
value2 | Optional | Additional items, cell references, or ranges to include in the count. You can add up to 255 arguments. |
What it returns: COUNT returns a whole number representing how many of the supplied values are numeric. Text, blanks, logical values (TRUE/FALSE), and error values are ignored.
COUNT examples
1 Count numbers in a simple list
This example shows COUNT working on a single column of mixed values. The goal is to find how many cells in B2:B6 contain numbers. The formula =COUNT(B2:B6) checks each cell: 10 and 20 are numbers, 'apple' is text, 30 is a number, and the blank cell is ignored. COUNT returns 3 because three cells hold numeric values.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Value | |||
| 2 | Pen | 10 | 3 | ||
| 3 | Pencil | 20 | |||
| 4 | Eraser | apple | |||
| 5 | Ruler | 30 | |||
| 6 | Sharpener | ||||
| 7 |
2 Count numeric scores in a student list
Here COUNT helps a teacher see how many students have a numeric score. The range C2:C7 contains scores and one text entry ('absent'). The formula =COUNT(C2:C7) ignores the text and counts only the four numeric scores. It returns 4, telling the teacher that four students have recorded scores.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Student | Class | Score | |||
| 2 | Anna | Math | 85 | 5 | ||
| 3 | Ben | Math | 92 | |||
| 4 | Cara | Math | absent | |||
| 5 | Dan | Math | 78 | |||
| 6 | Eva | Math | 88 | |||
| 7 | Finn | Math | 95 | |||
| 8 |
3 Count numeric invoice amounts
An accounts clerk needs to know how many invoices have a numeric amount. The range D2:D8 includes amounts, one text value ('N/A'), and one blank. The formula =COUNT(D2:D8) counts only the five numeric amounts. It returns 5, which helps the clerk confirm how many invoices are ready for processing.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Invoice | Client | Date | Amount | |||
| 2 | INV-001 | Alpha Ltd | 2024-01-05 | 250 | 5 | ||
| 3 | INV-002 | Beta Co | 2024-01-06 | 400 | |||
| 4 | INV-003 | Gamma Inc | 2024-01-07 | N/A | |||
| 5 | INV-004 | Delta LLC | 2024-01-08 | 150 | |||
| 6 | INV-005 | Epsilon | 2024-01-09 | 300 | |||
| 7 | INV-006 | Zeta Corp | 2024-01-10 | 500 | |||
| 8 | INV-007 | Eta GmbH | 2024-01-11 | ||||
| 9 |
4 Count numeric responses in a survey
A survey coordinator wants to know how many respondents gave a numeric rating. The range E2:E9 contains ratings, two text answers ('yes' and 'no'), and one blank. The formula =COUNT(E2:E9) ignores the text and blank, counting only the six numeric ratings. It returns 6, showing how many people provided a number.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Respondent | Age | Gender | Satisfaction | Rating | |||
| 2 | R1 | 25 | F | High | 4 | 6 | ||
| 3 | R2 | 32 | M | Medium | 3 | |||
| 4 | R3 | 28 | F | High | 5 | |||
| 5 | R4 | 45 | M | Low | yes | |||
| 6 | R5 | 36 | F | Medium | 4 | |||
| 7 | R6 | 29 | M | High | 5 | |||
| 8 | R7 | 41 | F | Low | no | |||
| 9 | R8 | 33 | M | Medium | 3 | |||
| 10 |
Common COUNT errors and how to fix them
| Error | Why it happens | How to fix it |
|---|---|---|
| #VALUE! | You typed text directly into the formula without quotation marks, such as =COUNT(hello), so Excel treats it as an invalid name. | Put text arguments in double quotes, e.g. =COUNT("hello"), or better, refer to cells instead of typing text. |
| #NAME? | The function name is misspelled, for example =COUNTT(A1:A10). | Check the spelling: use =COUNT(...) exactly. |
| Wrong count (too low) | Numbers stored as text are ignored by COUNT. This often happens when data is imported or pasted from another system. | Convert text-numbers to real numbers using Text to Columns, VALUE, or by multiplying by 1. Then COUNT will include them. |
| Wrong count (too high) | You included cells that contain dates or times. Excel stores dates as numbers, so COUNT treats them as numeric. | If you only want to count plain numbers, exclude date cells or use a function like COUNTIF with criteria to filter them out. |
| #REF! | A referenced range was deleted or moved, leaving an invalid cell reference. | Edit the formula and reselect the correct range, or undo the deletion. |
Tips for using COUNT
- Use COUNT to quickly check how many numeric entries you have before calculating an average or sum.
- Remember that COUNT ignores blanks, text, logical values, and errors, so it is safe to point at a whole column.
- If you need to count non-empty cells of any type, use COUNTA instead.
- To count numbers that meet a condition, use COUNTIF or COUNTIFS.
- Dates and times are numbers to Excel, so COUNT will include them; use COUNTIF with criteria if you need to exclude them.
- Combine COUNT with other functions like SUM or AVERAGE to build summary reports.
Frequently asked questions
What is the difference between COUNT and COUNTA?
COUNT counts only cells with numbers. COUNTA counts all non-empty cells, including text, numbers, logical values, and errors.
Does COUNT count dates?
Yes, because Excel stores dates as serial numbers. If you need to exclude dates, use COUNTIF with criteria that target numbers only, or filter your data.
Why does COUNT return 0 when I can see numbers?
The numbers are probably stored as text. Look for a green triangle in the corner of the cell or check alignment. Convert them to numbers using Text to Columns or by multiplying by 1.
Can COUNT handle multiple ranges?
Yes. You can list up to 255 arguments, each a range or value, and COUNT will add up the numeric cells across all of them.
Does COUNT work with filtered or hidden rows?
COUNT includes all cells in the range, even if rows are hidden or filtered out. To count only visible cells, use SUBTOTAL with function number 2.
Related functions
Every example on this page was recalculated by SheetSkill’s spreadsheet engine. COUNT reference