The COUNTA function
Counts the cells that are not empty: numbers, text, logical values and errors.
Syntax
COUNTA(value1, [value2], ...)- value1
- The first value, cell or range.
- value2 (optional)
- More values or ranges.
Examples
C1=COUNTA(A2:A6)
| A | B | C | |
|---|---|---|---|
| 1 | Units | 4 | |
| 2 | 4 | ||
| 3 | n/a | ||
| 4 | 7 | ||
| 5 | |||
| 6 | 2 |
C1=COUNTA(A1:A6)
| A | B | C | |
|---|---|---|---|
| 1 | Units | 5 | |
| 2 | 4 | ||
| 3 | n/a | ||
| 4 | 7 | ||
| 5 | |||
| 6 | 2 |