Skip to content

Excel function · Statistics

Excel COUNT function

COUNT returns how many cells in a range contain numbers, dates and times included: how many invoices have an amount, how many students have a score. Text and empty cells are not counted.

In Turkish Excel: BAĞ_DEĞ_SAY

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

English Excel=COUNT(value1, [value2], ...)
Turkish Excel=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

ArgumentRequiredDescription
value1RequiredThe first range, cell or value whose numbers are counted.
value2OptionalOptional 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).

D2fx=COUNT(B2:B7)
Count the invoices with an amount: example table
ABCDE
1InvoiceAmountEnteredMissing
2INV-10014,200.0042
3INV-1002
4INV-10039,999.90
5INV-1004Pending
6INV-100526,400.00
7INV-10061,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.

D2fx=COUNT(B2:B7)
COUNT versus COUNTA: example table
ABCDE
1StudentScoreNumbersNon-empty
2Mia9235
3LucasAbsent
4Ella70
5Jack
6Grace64
7HenryAbsent
  • 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".

E2fx=COUNT(C2:C6)
Count the orders with a delivery date: example table
ABCDE
1OrderCustomerDeliveredDelivered Orders
2S-1001Brown & Sons3-Oct-20253
3S-1002Northgate LtdIn transit
4S-1003Harbour Trade7-Oct-2025
5S-1004Star Market
6S-1005Brown & Sons9-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

Type this in Nexell

Add two cells that show how many invoices have an amount and how many are missing one

Convert to table

Bring 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").

Related functions

All statistics functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free