Prev: How to combine data from 2 separate workbooks onto 1 worksheet
Next: Average with Condition
From: iamjbunni on 17 Mar 2010 15:15
I have a formula that calculates averages each week. I need a formula that
automatically uses the cell below when new data is entered.
From: Mike H on 17 Mar 2010 15:25
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.
From: Gord Dibben on 17 Mar 2010 15:36
"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
<iamjbunni(a)discussions.microsoft.com> 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.

 | 
Pages: 1
Prev: How to combine data from 2 separate workbooks onto 1 worksheet
Next: Average with Condition