Average every seven cells, then copy formula

Giganews Newsgroups
Subject: Average every seven cells, then copy formula
Posted by:  iamnu (iamnu…@gmail.com)
Date: Thu, 10 Jul 2008

On my Averages worksheet, I have the following formulas:
In Cell A2:  ="Week " & WEEKNUM(Sheet1!E2,1)& " - " & TEXT(Sheet1!
E2,"mm/dd/yy")
In Cell B2:  =AVERAGE(Sheet1!F2:F8)    'compute values based on blocks
of 7 successive rows

I'd like to be able to COPY these formulas to row 3 so that the
formulas in Row 3 begin on Row 9 of Sheet1, Like this:

Cell A3:  ="Week " & WEEKNUM(Sheet1!E9,1)& " - " & TEXT(Sheet1!E9,"mm/
dd/yy")
Cell B3:  =AVERAGE(Sheet1!F9:F15)    'compute values based on blocks
of 7 successive rows

I need to copy the formulas in Cell A2 and B2 to thousands of cells on
the Averages worksheet.
Can someone explain how I change my formula's to accomplish this?

Replies