Calcualting Averages

[JohnEd]

I will use a simple example of what I want to do:

I need to add 3 cells (B2, C2, D2) together on a row to display th
average (by dividing total by 3) in cell E2. However, each week a ne
column will be added, in this case after D2, and a new figure will b
added, but the total still needs to calcuate the previous 3 cells.

Is there a formula I could use in the total column to calcuate th
totals of the 3 previous cells (as the cells to be calculated now wil
be C2, D2 and E2) without hardcoding?

Any help is much appreciated

+----------------------------------------------------------------
| Attachment filename: book1.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=360722
+----------------------------------------------------------------

 

[JMay]

In E2 enter:

=(SUM(OFFSET(E2,0,-3,1,3)))/3

 

[Dorota King]

even i have the same problem..any help would be greatful..