Moving cell formula

  • Thread starter Thread starter iamjbunni
  • Start date Start date
I

iamjbunni

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.
 
"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
 
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
 
Back
Top