I have a lot of daily data across several columns from in sheet 2 for about 100 different cases. Each case has the same data headings with 135 rows per case but differ in no of days ie some have 300 columns some have 100.

I have summarised the average weekly data for the first case in sheet 1 with formulas such as:

=AVERAGE(OFFSET(Sheet2!$E$132,,(COLUMNS(Sheet1$D$2:D2)-1)*7,,7))

This works quite well as when I drag the handle across it fills in the average for each subsequent week.

But what I want to do now is create a formula which does this for each case ie for each 132nd row so that when I drag the handle down the calculation is for each case.

Is this possible?

Can anyone help??