.

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

TAMIL NADU Seventh MATHEMATICS, SCIENCE AND SOCIAL SCIENCE BOOK FREE DOWNLOAD | TAMIL NADU 7TH MATHEMATICS, SCIENCE AND SOCIAL SCIENCE BOOK FREE DOWNLOAD

TAMIL NADU Sixth MATHEMATICS, SCIENCE AND SOCIAL SCIENCE BOOK FREE DOWNLOAD | TAMIL NADU 6TH MATHEMATICS, SCIENCE AND SOCIAL SCIENCE BOOK FREE DOWNLOAD