sum as running total
Type the formula =SUM($D$7:D7) in cell E7 and then copy down the table. It works because the first reference uses dollar symbols $ to keep $D$7 static as the formula is copied down. Each occurrence of the =SUM() then adds all the numbers from the first cell down.
The function can be tidied up to show 0 zero when there is no adjacent value by using the =IF() function.
Using =SUM() For A Running Total
Month | Sales | Running Total | |
Jan | 10 | 10 | =SUM($D$7:D7) |
Feb | 50 | 60 | =SUM($D$7:D8) |
Mar | 30 | 90 | =SUM($D$7:D9) |
Apr | 20 | 110 | =SUM($D$7:D10) |
May | 110 | =SUM($D$7:D11) | |
Jun | 110 | =SUM($D$7:D12) | |
Jul | 110 | =SUM($D$7:D13) | |
Aug | 110 | =SUM($D$7:D14) | |
Sep | 110 | =SUM($D$7:D15) | |
Oct | 110 | =SUM($D$7:D16) | |
Nov | 110 | =SUM($D$7:D17) | |
Dec | 110 | =SUM($D$7:D18) |
Month | Sales | Running Total | |
Jan | 10 | 10 | =SUM (IF(D7,$D$7:D7,0)) |
Feb | 50 | 60 | =SUM (IF(D8,$D$7:D8,0)) |
Mar | 30 | 90 | =SUM (IF(D9,$D$7:D9,0)) |
Apr | 20 | 110 | =SUM (IF(D10,$D$7:D10,0)) |
May | 0 | =SUM (IF(D11,$D$7:D11,0)) | |
Jun | 0 | =SUM (IF(D12,$D$7:D12,0)) | |
Jul | 0 | The =SUM() only takes place when | |
Aug | 0 | there is data in column D. | |
Sep | 0 | Otherwise the value 0 zero is entered. | |
Oct | 0 | ||
Nov | 0 | ||
Dec | 0 |