software

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

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