0 of 46 lessons complete.
Module 6: Conditional Math · Lesson 33 of 46
SUMIF with Sum Range
Check one column and add up another.
Step 1 of 20%
SUMIF can check one range and add another: =SUMIF(range to check, condition, range to add). In E2, total the load for North substation. Use D2 as the condition.
Target: E2
A1
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Substation | Feeder Load (MW) | Substation | Total Load (MW) | ||
| 2 | North | 3.2 | North | |||
| 3 | South | 4.1 | South | |||
| 4 | North | 2.8 | East | |||
| 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 $