0 of 46 lessons complete.
Module 2: Core Functions · Lesson 9 of 46
SUM Function
Add up a range of cells with SUM.
Step 1 of 10%
Functions are built-in formulas. SUM adds every number in a range. In B8, type =SUM(B2:B7) to get total substation load.
Target: B8
A1
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Feeder | Load (MW) | ||||
| 2 | F1 | 4.2 | ||||
| 3 | F2 | 3.8 | ||||
| 4 | F3 | 5.1 | ||||
| 5 | F4 | 2.9 | ||||
| 6 | F5 | 6.3 | ||||
| 7 | F6 | 4.7 | ||||
| 8 | Total | |||||
| 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 $