0 of 46 lessons complete.
Module 2: Core Functions · Lesson 14 of 46
COUNTA & Blank Cells
Count filled cells and find missing data.
Step 1 of 20%
COUNTA counts every cell that isn't empty. In E1, count how many flow readings were logged.
Target: E1
A1
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Minute | Flow (L/s) | Readings logged | |||
| 2 | 1 | 5.2 | Missing readings | |||
| 3 | 2 | 5.4 | ||||
| 4 | 3 | |||||
| 5 | 4 | 5.1 | ||||
| 6 | 5 | 5.3 | ||||
| 7 | 6 | |||||
| 8 | 7 | |||||
| 9 | 8 | 5.5 | ||||
| 10 | 9 | 5 | ||||
| 11 | 10 | 5.2 | ||||
| 12 | ||||||
| 13 | ||||||
| 14 | ||||||
| 15 | ||||||
| 16 | ||||||
| 17 | ||||||
| 18 | ||||||
| 19 | ||||||
| 20 | ||||||
| 21 | Missing | |||||
| 22 |
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 $