0 of 46 lessons complete.
Module 2: Core Functions · Lesson 13 of 46
COUNT Function
Count how many cells contain numbers.
Step 1 of 10%
The sensor logged ERR twice. In E1, use COUNT to find how many valid numeric readings there are.
Target: E1
A1
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Sample | Voltage (V) | Valid readings | |||
| 2 | 1 | 12.1 | ||||
| 3 | 2 | 11.8 | ||||
| 4 | 3 | ERR | ||||
| 5 | 4 | 12.4 | ||||
| 6 | 5 | 12 | ||||
| 7 | 6 | ERR | ||||
| 8 | 7 | 11.9 | ||||
| 9 | 8 | 12.3 | ||||
| 10 | 9 | 12.2 | ||||
| 11 |
Arrow keys move · drag or shift-click to select a range · Ctrl/Cmd+D fill down · Ctrl/Cmd+R fill right · Alt+= AutoSum · F4 toggles $