How to average one constant # to variable #s? A1:A2 A1:A3 A1:A4

I am trying to average a column from cell 1 to the most recently added cell.
A1 is the constant cell. All succeeding cells are to be averaged from A1.
However, when I copy and paste, both numbers change (A1:A2 - A2:A3 - A3:A4).
What I need is a constant A1 (A1:A2 - A1:A3 - A1:A4). Any ideas would be
appreciated!

Hi!

Try this:

=AVERAGE(A$1:A2)

Copy down as needed.

This will increment as you copy:

=AVERAGE(A$1:A2)
=AVERAGE(A$1:A3)
=AVERAGE(A$1:A4)
=AVERAGE(A$1:A5)

Biff

"Colfax" <Colfax@discussions.microsoft.com> wrote in message
news:5223812D-A812-4440-A3BD-ABFB648DB918@microsoft.com...
>I am trying to average a column from cell 1 to the most recently added
>cell.
> A1 is the constant cell. All succeeding cells are to be averaged from A1.
> However, when I copy and paste, both numbers change (A1:A2 - A2:A3 -
> A3:A4).
> What I need is a constant A1 (A1:A2 - A1:A3 - A1:A4). Any ideas would be
> appreciated!