Continuous Averages Formula

You know how you can set an entire column with the same formula by dragging at the bottom right hand corner of a formulized block... well I need help with a formula. Its a bit complicated to explain, but I'll try my best.

I want a formula that will keep the running averages.

100 ave: 100.0
105 ave: 102.5
180 ave: 128.3
100 ave: 121.3

When I type in =AVERAGE(A1:A2)

then I drag down the formula to affect the other lines...

I want them to show

=AVERAGE(A1:A3)
=AVERAGE(A1:A4), etc...

but it ends up showing

=AVERAGE(A2:A3)
=AVERAGE(A3:A4)

Please help.

You need to lock the start row down. You do this with absolute referencing
of the row.

Use

=AVERAGE(A$1:A2)

and copy down

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Mof" <[email protected]> wrote in message
news:[email protected]...
>
> You know how you can set an entire column with the same formula by
> dragging at the bottom right hand corner of a formulized block... well
> I need help with a formula. Its a bit complicated to explain, but I'll
> try my best.
>
> I want a formula that will keep the running averages.
>
> 100 ave: 100.0
> 105 ave: 102.5
> 180 ave: 128.3
> 100 ave: 121.3
>
> When I type in =AVERAGE(A1:A2)
>
> then I drag down the formula to affect the other lines...
>
> I want them to show
>
> =AVERAGE(A1:A3)
> =AVERAGE(A1:A4), etc...
>
> but it ends up showing
>
> =AVERAGE(A2:A3)
> =AVERAGE(A3:A4)
>
> Please help.
>
>
> --
> Mof
> ------------------------------------------------------------------------
> Mof's Profile:
http://www.excelforum.com/member.php...o&userid=30892
> View this thread: http://www.excelforum.com/showthread...hreadid=505660
>

Thank You!