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

[Guest]

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!

 

[Biff]

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