The COUNT function
Counts the cells that hold numbers (dates count too). Text, blanks and errors are not counted.
Syntax
COUNT(value1, [value2], ...)- value1
- The first value, cell or range.
- value2 (optional)
- More values or ranges.
Examples
C1=COUNT(A2:A6)
| A | B | C | |
|---|---|---|---|
| 1 | Units | 3 | |
| 2 | 4 | ||
| 3 | n/a | ||
| 4 | 7 | ||
| 5 | |||
| 6 | 2 |
C1
=COUNT(1A2:A6,210)| A | B | C | |
|---|---|---|---|
| 1 | Units | 4 | |
| 2 | 4 | ||
| 3 | n/a | ||
| 4 | 7 | ||
| 5 | |||
| 6 | 2 |
In plain words: Count the numbers 1in A2:A6 plus 2the number 10.