Prevent auto incrementation of formula
"Marie Bayes" wrote:
Does anyone know of a way to prevent formula from automatically updating
themselves when new cells are added into a range.
Marie
In a blank cell type the range you want to sum e.g. A1:A20 Then enter the
formula
=SUM(INDIRECT(C1)) where C1 is the cell in which you entered the range to be
summed.
You can change the font colour to white so that it is hidden and not shown
in a print.
Regards
Peter
|