- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2008 July
- Average every seven cells, then copy formula

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?

- Re: Average every seven cells, then copy formula posted by Zumble on Thu, 10 Jul 2008