## SCHOOL BOOKS

### EXAM TIME TABLE 2018 -- +2 +110TH

 Tamilnadu School Books Change for Academic Years Standards Academic year 2, 7, 10 & 12 2019-20 3, 4, 5 & 8 2020-21

STD - 1
STD - 2
STD - 3
STD - 4
STD - 5
STD - 6
STD - 7
STD - 8
STD - 9
STD - 10
STD - 11
STD - 12

### SUM (Running Total) Function Dictionary

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