SUM (Running Total) Function (Functions in Excel)

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)

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.

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

Related Posts by Categories