# COUNT function in Excel

> COUNT tells you how many cells contain numbers.

Source: https://spreadsheetpractice.com/functions/count · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** COUNT tells you how many cells contain numbers.
- **Syntax:** `=COUNT(value1, [value2], ...)`
- **Most common use:** `=COUNT(B2:B6)` returns 4 (Four amounts; the word "pending" isn't a number)
- **Available in:** Every current version
- **Category:** [Statistical functions](https://spreadsheetpractice.com/functions/category/stats)
- **Returns:** The number of numeric values.
- **Google Sheets:** Also available in Google Sheets.

## What it does

COUNT tells you how many cells contain numbers. Dates count too, because Excel stores them as numbers, while text, empty cells and errors are skipped. It's useful for checking how many entries have a value filled in, and for spotting numbers that were imported as text.

## Syntax

`=COUNT(value1, [value2], ...)`

| Argument | Required? | What it is |
|---|---|---|
| `value1` | Required | The first value, cell or range to count. |
| `value2` | Optional | More values, cells or ranges, up to 255 in total. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| F2 | `=COUNT(B2:B6)` | 4 | Four amounts; the word "pending" isn't a number |
| F3 | `=COUNT(C2:C6)` | 3 | Dates are numbers, so this counts the paid invoices |
| F4 | `=COUNT(A2:A6)` | 0 | Zero, because the IDs are text. Use COUNTA for text |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Invoice | Amount | Paid on |  | Check | Result |
| 2 | INV-101 | $450 | 3/4/2026 |  | Amounts entered | 4 |
| 3 | INV-102 | pending |  |  | Invoices paid | 3 |
| 4 | INV-103 | $1,200 | 3/11/2026 |  | Invoice IDs | 0 |
| 5 | INV-104 | $780 |  |  |  |  |
| 6 | INV-105 | $310 | 3/20/2026 |  |  |  |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| COUNT returns 0 on a column of names | COUNT only counts numbers. Use COUNTA to count any non-empty cell. |
| Numbers aren't being counted | They're stored as text, often after an import. Look for left-aligned numbers or a green triangle in the corner. |

## Tips

- Compare COUNT and COUNTA on the same column to find entries that should be numbers but aren't.

## Related functions

- [COUNTA](https://spreadsheetpractice.com/functions/counta): COUNTA counts every cell that isn't empty: text, numbers, dates, errors and even formulas that return empty text.
- [COUNTBLANK](https://spreadsheetpractice.com/functions/countblank): COUNTBLANK counts the empty cells in a range: unassigned tasks, unanswered questions, missing dates.
- [COUNTIF](https://spreadsheetpractice.com/functions/countif): COUNTIF counts the cells in a range that meet one condition: tickets marked "Open", scores of 70 or more, product names containing "lamp".

## Questions

### What is the difference between COUNT and COUNTA?

COUNT counts only numbers (including dates). COUNTA counts every non-empty cell, including text.

### Does COUNT count dates?

Yes. Dates are stored as numbers, so COUNT includes them.

## Practice

A graded COUNT exercise ("Counting cells") is on [the COUNT page](https://spreadsheetpractice.com/functions/count). It is checked instantly, then re-checked on changed data.

Lessons that use COUNT:

- [Lesson 2: SUM, AVERAGE, MIN, MAX & COUNT](https://spreadsheetpractice.com/learn/sum-average-min-max-count)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
