Statistical
Modern
COUNTA
Counts how many cells in a range are not empty.
Available in All versions
Syntax
COUNTA(value1, [value2])What it returns
The count of non-empty cells.
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 | City |
| 2 | Paris |
| 3 | |
| 4 | Lyon |
| 5 | Nice |
Count
3
COUNTA counts every non-empty cell, numbers or text, skipping blanks (3).
=COUNTA(A2:A100)Important to know
Counts cells of any type (text, numbers, errors) — only truly empty cells are skipped.
A formula returning "" counts as non-empty.