0 of 46 lessons complete.
Module 6: Conditional Math · Lesson 32 of 46
Intro to SUMIF
Add up only the values that meet a condition.
Step 1 of 10%
SUMIF adds only the cells that meet a condition. In E1, total the load on feeders carrying more than 4 MW.
Target: E1
A1
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Substation | Feeder Load (MW) | Load from feeders over 4 MW | |||
| 2 | North | 3.2 | ||||
| 3 | South | 4.1 | ||||
| 4 | North | 2.8 | ||||
| 5 | East | 5 | ||||
| 6 | South | 3.6 | ||||
| 7 | North | 4.4 | ||||
| 8 | East | 2.5 | ||||
| 9 |
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 $