Statistical
Modern
COUNT
Counts how many cells in a range contain numbers.
Available in All versions
Syntax
COUNT(value1, [value2])What it returns
The count of numeric values.
Arguments
| Argument | Required | Description |
|---|---|---|
value1 |
Yes | The first item or range to count. |
value2 |
No | Additional items or ranges (up to 255). |
Example
| A | |
|---|---|
| 1 | Amount |
| 2 | 10 |
| 3 | N/A |
| 4 | 25 |
| 5 | 30 |
Count
3
COUNT counts only the cells that contain numbers — text is ignored (3).
=COUNT(B2:B100)Important to know
Counts only numbers (and dates) — ignores text and blanks.
To count non-empty cells of any type, use COUNTA.