Averaging previous cells

[mrobertson]

I currently have a list of data with several values. I want to add
colunm with which the first row will be the average of tha
column(hence just that value), the second row will be the average o
the second row and the first row, the third row will be the average o
the first second and third row. Can anyone help me as to how I woul
be able to do this?

ex) I need something that increment the 2nd term in the averag
function:

average(A1:A1)
average(A1:A2)
average(A1:A3)
average(A1:A4)
average(A1:A5)
average(A1:A6

 

[Bob Phillips]

=AVERAGE($A$1:A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Nick Hodge]

mrrobnertson

make the first part absolute like so

=AVERAGE($A$1:A1)

and copy down.

Check relative and absolute references in help. (Tip: shortcut to enter the
$ while entering the function, press F4, it will toggle through the four
available options)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[mrobertson]

Thank you for you help. It worked perfectly