Quote Originally Posted by cjohnsen
the number of lines chang about every 10,000 lines. going from 25 rows in between for 10,000 lines then the next data set goes to 30 for 10,000 rows then 40. i may have to go 50 later on

the cell i need sums the 25 rows in between. so to drag the previous formula down, works great and saves me Tons of time! only when the rows in between the value needed goes to 30 then 40 that formula no longer works.

let me know if i can provide any more info....
The simplest way would probably be to have an extra column to indicate which row you going to grab data from. I'll just say it's Column C so that it is consistent with previous lines.

In A1 and down:
=INDIRECT(ADDRESS(C1,COLUMN(T:T),1,1, "sheet 1"))

T3300 is the first row, T13300 is where the increment changes, T23300 is where it changes again, etc.

In C1:
= ROW('sheet 1'!T3300)

In C2 and down:
= IF(C1<ROW('sheet 1'!T13300),C1+25, IF(C1<ROW('sheet 1'!T23300),C1+30,C1+40))

To combine these two formula is possible, but it will be more complicated.

Scott