COUNTA
Counts how many values are in the list of arguments.
StatisticalBeginner EssentialsMost UsedStatistics & Analysis
What it does
Counts how many cells in a range are non-empty (numbers, text, logicals, errors).
Syntax
COUNTA(value1, [value2], ...)
Arguments
value1(value|range) — First value or range to evaluate.
Examples
Count non-empty cells
Count non-blank cells in A2:A7.
FORMULA
=COUNTA(A2:A7)
RESULT
5
SAMPLE DATA
| A | |
|---|---|
| 1 | Mixed values |
| 2 | 10 |
| 3 | |
| 4 | 7 |
| 5 | 3 |
| 6 | 0 |
| 7 | N/A |