A running total with a growing range
PremiumIn C2, start a running total that can be filled down to C7: SUM a range that starts at a locked $B$2 and ends at a relative B2.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Month | Sales | Running total | |||
| 2 | January | 120 | ||||
| 3 | February | 95 | ||||
| 4 | March | 140 | ||||
| 5 | April | 110 | ||||
| 6 | May | 135 | ||||
| 7 | June | 150 | ||||
| 8 |
Premium lesson
Unlock Relative and absolute references and every other lesson
This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.
Next with premium:PercentagesIF
Need help?
Why this works
The start of the range is locked and the end is not. In C2 the range is $B$2:B2, just January. Filled down, C3 reads $B$2:B3 and C7 reads $B$2:B7, so each row adds up every month so far. June's running total is the year-to-date figure, 750.
Common mistake: Locking both ends or neither. With $B$2:$B$2 every row shows January; with B2:B2 every row shows only its own month.
The answer
- C2
=SUM($B$2:B2)
In the first row write =SUM($B$2:B2) and fill it down. The start of the range stays on the first value and the end moves with each row.