Excel 2007 average formula

  • Thread starter Thread starter Tony O
  • Start date Start date
T

Tony O

I am using Excel 2007 for my reports.

I have a cell to find the average of cell E10 and the five cells above
it.

My formula is this:
=AVERAGE(E6:E10)

Every day I add a new row with new data. In this example it will be
in E11.
How do I get the average formula to automatically recalculate so
with the new data it will calculate cell E11 and the five cells above
it?
The formula should now be:
=average(E7:E11)

Every day I have new sales data that moves the data.

If you have any thoughts on this, it will be appreciated. I have
multiple formulas that I have to update
on a daily basis.
 
hi Tony,

=MOYENNE(INDIRECT("E"&LIGNE()-5&":E"&LIGNE()-1))

--
isabelle



Le 2012-05-02 19:44, Tony O a écrit :
 
sorry,

=AVERAGE(INDIRECT("E"&ROW()-5&":E"&ROW()-1))

--
isabelle



Le 2012-05-02 22:12, isabelle a écrit :
 
Back
Top