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.