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!