Simple average question

[dtpetty]

I'm sure this is a ridiculously simple question for most of you folks
but I've been trying to find an answer for hours and hours.

I have a column of values. In the next column I sinply want the average
including data down to that row. So far I have been editing the formula
manually but this gets old for several thousand values.

In case my question is not clear I will show formulae I am using to get
what I want:

In column B starting with row 1 and moving down (the data are in column
A):

B1=AVERAGE(A1:A1)
B2=AVERAGE(A1:A2)
B3=AVERAGE(A1:A3)
B4=AVERAGE(A1:A4)

I guess I'm looking for some king of relative addressing, and then how
do I apply the formula to all the cells in that column?

Thanks much in advance for your help.

 

[Ken Wright]

B1=AVERAGE($A$1:A1)

and copy down

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------