Sum formula Update

[littleps]

I’ve got numbers in cells A1, B1, C1. Cell D1 is a sum of A1, B1, C1.
When I insert column before D1 and then put a number, cell E1
(previously D1) is the same sum as it was, i.e. (A1+B1+C1). Is there a
way this formula to be updated automatically when I insert column
before the cell with Sum formula, i.e. (A1+B1+C1+D1)? Strange, but this
is an issue with old excel, not new one.

Thanks.

 

[Niek Otten]

Use one extra column and insert before that one. The range of the SUM will
be automatically extended.

 

[Pete_UK]

You could highlight column C and insert a new column there. If you want
the data that was in C (now D) to be put back in C you can copy it
across then delete the data in column D. Do not MOVE the data
(cut/paste), as this will adjust the formula again. When deleting the
data from D, highlight the column then press the <Delete> key, not
Insert | Delete.

Hope this helps.

Pete

 

[Pete_UK]

Sorry, I had assumed you have a formula like =SUM(A1:C1). If, instead,
you have =A1+B1+C1 then the range will not automatically get extended
in older versions of Excel.

Pete

 

[Niek Otten]

Good point! I missed that, too!

 

[littleps]

Thanks. Just thought that formula SUM(A1:C1) can be added up with som
"complications" to avoid extra column or additional manual work