## 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