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

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" wrote in message
...

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!


--
Mof
------------------------------------------------------------------------
Mof's Profile: http://www.excelforum.com/member.php...o&userid=30892
View this thread: http://www.excelforum.com/showthread...hreadid=505660