.

SUM (Running Total) Function Dictionary

Function Dictionary Function Examples Function Categories

SUM (Running Total)        
 
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

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download