Level 1Core FunctionsPractice, 3 min
COUNT only the numbers
The task
Survey answers are mixed in with notes. In C2, count how many responses in A2:A8 are numbers.
The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | |
|---|---|---|---|
| 1 | Response | Numeric | |
| 2 | 4 | ||
| 3 | n/a | ||
| 4 | 7 | ||
| 5 | |||
| 6 | 9 | ||
| 7 | skip | ||
| 8 | 3 |