Okay, if I understand you right you have a bunch of data in 128 columns, with sums at the bottom of each column. You then need to work out a sliding average of groups of 5 of those sums.
If I'm right, then the best way I can think of would be to have a row of the starting columns for each range, i.e:
1 6 11 16 ... etc.
And then a formula that picks up the correct columns from there, i.e. if they'reon row 102 and the averages are on row 100:
It might be easier to use named ranges. For example, if you named the first 'block' of data (B6:F56) "rng1" and the second block (G6:K56) "rng2" and so on, you could use:
If I'm right, then the best way I can think of would be to have a row of the starting columns for each range, i.e:
1 6 11 16 ... etc.
And then a formula that picks up the correct columns from there, i.e. if they'reon row 102 and the averages are on row 100:
=AVERAGE(INDIRECT("R100C"&
You'll have to change that to the appropriate row numbers, of course.
If i've misunderstood you please ignore this!