Excel won't pick up my cell pattern

[deck0120]

Hello,

I am having trouble getting Excel to pick up on a pattern. I have two spreadsheets. Sheet 1 contains data and Sheet 2 is form statistical computations on sheet 1 data. I think the reason is beause my computations use the same cell twice. How can I overcome this? Here is simple pattern of what I would like to do. Each time the range increases by 6 but still uses the last cell from the previous computation. I would like to be able to drag this pattern across the entire spreadsheet since there are nearly 5000 cells but Excel will not pick up the pattern.

=AVERAGE(Data!A1:A6)
=AVERAGE(Data!A6:A12)
=AVERAGE(Data!A12:A18)

 

[mikerickson]

A1:A6 has 6 cells, A6:A12 has 7 cells, A12:A18 has 7 cells (breaking the pattern of increasing range size)

What pattern are you using?

 

[Oaktree]

Assuming, as in Mike's question above, that you actually want 6 cells in the first group and 7 thereafter, try

B1 =AVERAGE(Data!A1:A6)
B2 =AVERAGE(OFFSET(Data!$A$1,(ROW()-1)*6-1,,7)) copied down

 

[deck0120]

I sorry for the confusion. I would like 7 cells for each computation.

 

[mikerickson]

Modifying Oaktree's solution to
B1 =AVERAGE(OFFSET(Data!$A$1,(ROW()-1)*6+1,,7)) copied down

Will give the ranges A1:A7, A7:A13, A13:19, A19:A25, ...

 

[deck0120]

Thanks for the help! Everything Works Great! For anyone else looking at this posting. Make sure you start in the first row for this to work. I started in Row 4 and had to modify the equation a bit to get the correct result.