ExcelBanter - help copying formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - help copying formulas (https://www.excelbanter.com/excel-discussion-misc-queries/193314-help-copying-formulas.html)

help copying formulas

Here is my scenario:

Column A of my worksheet contains data in A1:A364 (representing daily values
for one year)
I want Column B to contain weekly averages, i.e. B1=average(A1:A7).
When I copy the formula to B2, Excel makes the formula B2=average(A2:A8).

Is there a way for me to be able to copy the formula such that I get the
correct results, B2=average(A8:A14), B3=average(A15:A21) ...
B52=average(A358:A364)?

Thanks in advance for any assistance provided.

help copying formulas

=AVERAGE(OFFSET($A$1,ROW()*7-7,0):OFFSET($A$1,ROW()*7-1,0))

"mgnrke28" skrev:

Here is my scenario:

Column A of my worksheet contains data in A1:A364 (representing daily values
for one year)
I want Column B to contain weekly averages, i.e. B1=average(A1:A7).
When I copy the formula to B2, Excel makes the formula B2=average(A2:A8).

Is there a way for me to be able to copy the formula such that I get the
correct results, B2=average(A8:A14), B3=average(A15:A21) ...
B52=average(A358:A364)?

Thanks in advance for any assistance provided.