SUM AS RUNNING TOTAL

Posted on 18-01-2020 , by: admin , in , 0 Comments

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

Leave a comment