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.
automatically uses the cell below when new data is entered.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
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.
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.
G
Gord Dibben
"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
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
A
Ashish Mathur
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
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