Average every seven cells, then copy formula

  • Thread starter Thread starter iamnu
  • Start date Start date
I

iamnu

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?
 
I need to copy the formulas in Cell A2 and B2 to thousands of cells on
the Averages worksheet.
Click to expand...


Please don't do that.
Use pivot tables to calculate averages.

Zumble
 
Please don't do that.
Use pivot tables to calculate averages.

Zumble
Click to expand...

Thanks, Zumble!

I don't know how to use pivot tables yet, but I can see how this will
solve my problem.
I appreciate your help.
 
Back
Top