You could Highlight the entire A column and enter a name into the Name box
Like MyRange then change your formula to this
=AVERAGE(MyRange)

"Brian Young" wrote:

i need to execute a formula on a column of data that is growing. how can i
automatically accomodate this growing range ?

=AVERAGE(A1:A10) with A10 increasing

any suggestions would be appreciated

brian