0 of 46 lessons complete.
Module 6: Conditional Math · Lesson 31 of 46
COUNTIF
Count cells that meet a condition.
Step 1 of 20%
COUNTIF counts cells that match a condition. In F1, count how many parts FAILED.
Target: F1
A1
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Part | Diameter (mm) | Status | Failed parts | |||
| 2 | P1 | 10.01 | PASS | Oversized parts | |||
| 3 | P2 | 10.08 | FAIL | ||||
| 4 | P3 | 9.97 | PASS | ||||
| 5 | P4 | 10.03 | PASS | ||||
| 6 | P5 | 9.91 | FAIL | ||||
| 7 | P6 | 10 | PASS | ||||
| 8 | P7 | 10.04 | PASS | ||||
| 9 | P8 | 9.99 | PASS | ||||
| 10 | P9 | 10.06 | FAIL | ||||
| 11 | P10 | 10.02 | PASS | ||||
| 12 | |||||||
| 13 | |||||||
| 14 | |||||||
| 15 | |||||||
| 16 | |||||||
| 17 | |||||||
| 18 | |||||||
| 19 | |||||||
| 20 | |||||||
| 21 | Oversized parts | ||||||
| 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 $