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 |
