Moving cell formula

I have a formula that calculates averages each week. I need a formula that
automatically uses the cell below when new data is entered.

Hi,

Average is clever enough to ignore empty cells so why not

=AVERAGE(A:A)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"iamjbunni" wrote:

I have a formula that calculates averages each week. I need a formula that
automatically uses the cell below when new data is entered.

"cell below" what?

Where is the formula and what is the range it averages?

If you place =AVERAGE(A:A) into B1 then as you add data to column A your
formula in B1 will pick up the new data.

Or place this formula in A2 and insert a row above for each new piece of
data.

=AVERAGE(A1:INDEX(A:A,ROW()-1))


Gord Dibben MS Excel MVP


On Wed, 17 Mar 2010 12:15:02 -0700, iamjbunni
wrote:

I have a formula that calculates averages each week. I need a formula that
automatically uses the cell below when new data is entered.

Hi,

If you want to include every new row in the average formula, then you may
convert the range to a List/Table (Ctrl+T). Select the entire range
(including the header row) and press Ctrl+T. When you convert a range to a
Table, it auto expands in every formula in which the range ie being used in
the workbook

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"iamjbunni" wrote in message
...
I have a formula that calculates averages each week. I need a formula
that
automatically uses the cell below when new data is entered.