Selecting a range of values from high frequency data

Dear all,

I have a very long list of high frequency data in excel, (over 190,000 rows). What i would like to do is to be able to select every 9000 cells as i go down the list and return the sum of those cells into a cell on another worksheet.

My original plan was to do cell: =(SUM(CELL1:CELL9000)) and then change the next cell to: =(SUM(CELL9001:18000))
However this will take forever to do when in some worksheets i have almost half a million lines.

Is there some sort of programming function or macro that i can use that will allow me to select every 9000cells from this data range. Your help would be appreciated.
thanks