Here is an example, you can modify it for your formula
=AVERAGE(INDIRECT("A4:A23")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Marie Bayes" wrote in message
...
Does anyone know of a way to prevent formula from automatically updating
themselves when new cells are added into a range.
I'm trying to base a calculation on the first 20 cells in a range of
cells,
additional cells will be inserted at the start of this range, but I don't
want the formula to update the range past the first 20 cells. (I'm
getting
an average of the 20 latest figures to be entered, if that helps). Thanks
in
advance.