What it does
COUNT counts only numbers. Dates and times are numbers in Excel, so they count too; text, empty cells, TRUE/FALSE values and errors do not. =COUNT(C2:C50) returns the number of rows with an amount filled in.
To count every non-empty cell, text included, use COUNTA; to count empty cells, COUNTBLANK; to count cells that meet a condition, COUNTIF.
Numbers stored as text are not counted. If COUNT and COUNTA give different results for a column, either some cells hold text or some numbers are stored as text; it is a quick way to spot problems in imported data.
Syntax
=COUNT(value1, [value2], ...)=BAĞ_DEĞ_SAY(değer1; [değer2]; ...)Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
value1 | Required | The first range, cell or value whose numbers are counted. |
value2 | Optional | Optional further ranges or values, up to 255 arguments. |
Examples
1Count the invoices with an amount
Some invoices have no amount yet, and one says "Pending". D2 counts the cells with numbers; E2 counts the rest (empty or text).
=COUNT(B2:B7)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Invoice | Amount | Entered | Missing | |
| 2 | INV-1001 | 4,200.00 | 4 | 2 | |
| 3 | INV-1002 | ||||
| 4 | INV-1003 | 9,999.90 | |||
| 5 | INV-1004 | Pending | |||
| 6 | INV-1005 | 26,400.00 | |||
| 7 | INV-1006 | 1,875.50 |
- D2
=COUNT(B2:B7) - E2
=ROWS(B2:B7)-COUNT(B2:B7)
4 of the six invoices have an amount and 2 are missing one. "Pending" is not a number, so it is not counted.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2COUNT versus COUNTA
Students who missed the exam have "Absent" instead of a score, and one student has no score yet. The two functions give different results on the same range.
=COUNT(B2:B7)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Student | Score | Numbers | Non-empty | |
| 2 | Mia | 92 | 3 | 5 | |
| 3 | Lucas | Absent | |||
| 4 | Ella | 70 | |||
| 5 | Jack | ||||
| 6 | Grace | 64 | |||
| 7 | Henry | Absent |
- D2
=COUNT(B2:B7) - E2
=COUNTA(B2:B7)
3 students have a score; the non-empty count is 5, because the cells that say "Absent" are not empty either.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
3Count the orders with a delivery date
Excel stores dates as numbers, so COUNT counts cells with dates too. Orders not delivered yet have no date or say "In transit".
=COUNT(C2:C6)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Order | Customer | Delivered | Delivered Orders | |
| 2 | S-1001 | Brown & Sons | 3-Oct-2025 | 3 | |
| 3 | S-1002 | Northgate Ltd | In transit | ||
| 4 | S-1003 | Harbour Trade | 7-Oct-2025 | ||
| 5 | S-1004 | Star Market | |||
| 6 | S-1005 | Brown & Sons | 9-Oct-2025 |
3 orders have a delivery date; the rows that say "In transit" or are empty are not counted.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- Count too low
Cause: Some numbers are stored as text; a green triangle appears in the corner of those cells and they are not counted.
Fix: Select the cells and use Convert to Number, or convert them with VALUE.
- Dates are counted too
Cause: The range includes a date or time column; Excel stores dates as numbers.
Fix: Limit the range to the column you want to count.
Good to know
- To see how many values are missing from a column, use
=ROWS(C2:C50)-COUNT(C2:C50). - To check whether a column that should hold only numbers contains text, look at
=COUNTA(C2:C50)-COUNT(C2:C50); anything above 0 means there is text.
In Nexell
Get Nexell to do it from a sentence
Add two cells that show how many invoices have an amount and how many are missing one
Convert to tableBring your invoice list into the tool and type this. Nexell builds the counts with real Excel formulas and shows them in the preview first; in the downloaded file, the counts update as you fill in the missing amounts.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
What is the difference between COUNT and COUNTA?
COUNT counts only cells with numbers (and dates). COUNTA counts every non-empty cell: text, numbers, dates, logical values or errors.
How do I count the numbers in a column?
Use =COUNT(C2:C50). To count with a condition, such as values above 1,000, use COUNTIF: =COUNTIF(C2:C50,">1000").