Hi,


This is what I currently have <Please refer to the sample excel document to get a better idea>:

Google Drive:
https://docs.google.com/file/d/0B89c...it?usp=sharing


I currently have =sum() formula in the STARTING from the column range:
EA101 --> =SUM(CA101:CA105) <<sum of 5 rows>>
Drag to autofill across, and to bottom, 4 rows above the data source (DA101:DW421). Otherwise, it will sum blank cells.

GA101 --> =SUM(CA101:CA106) <<sum of 6 rows>>
Drag to autofill across, and to bottom, 5 rows above the data source (DA101:DW421). Otherwise, it will sum blank cells.

iA101 --> =SUM(CA101:CA110) <<sum of 10 rows>>
Drag to autofill across, and to bottom, 9 rows above the data source (DA101:DW421). Otherwise, it will sum blank cells.

KA101 --> =SUM(CA101:CA115) <<sum of 15 rows>>
Drag to autofill across, and to bottom, 14 rows above the data source (DA101:DW421). Otherwise, it will sum blank cells.

MA101 --> =SUM(CA101:CA120) <<sum of 20 rows>>
Drag to autofill across, and to bottom, 19 rows above the data source (DA101:DW421). Otherwise, it will sum blank cells.



The Sample excel I have uploaded only consists of 321 rows (CA101:DW421).
However, the actual data (multiple sets of data) that I have consists of 300000+ rows.


As a result, the =sum() function that I have takes too long to caculate/out of memory everytime I provide new data from CA101:DW.


I am wondering if there is a faster way, maybe a macro, that could do the calculation instead of using the formlua?



Thanks,

Sheldon