T
tepermanj
If I insert a formula, e.g. =SUM(C1:C5). Then I delete row 3. Excel will
redesignate the cells, C4 will become C3 and C5 will become C4. The formula
will also be updated accordingly to =SUM(C1:C4).
However, if I have formulas in a column, e.g. A2 has the formula =SUM(A1+1),
A3 has the formula =SUM(A2+1), etc..., the above does not happen. In other
words, the cells are redesignated, A4 will become A3, A5 will become A4,
etc... Unfortunately, the formulas are not reconfigured as they are in the
first example. Instead, the following error is received:
=SUM(#REF!+1)
Why does excel update formulas in certain instances and not in others?
Thanks.
redesignate the cells, C4 will become C3 and C5 will become C4. The formula
will also be updated accordingly to =SUM(C1:C4).
However, if I have formulas in a column, e.g. A2 has the formula =SUM(A1+1),
A3 has the formula =SUM(A2+1), etc..., the above does not happen. In other
words, the cells are redesignated, A4 will become A3, A5 will become A4,
etc... Unfortunately, the formulas are not reconfigured as they are in the
first example. Instead, the following error is received:
=SUM(#REF!+1)
Why does excel update formulas in certain instances and not in others?
Thanks.