Sum formula Update

  • Thread starter Thread starter littleps
  • Start date Start date
L

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.
 
Use one extra column and insert before that one. The range of the SUM will
be automatically extended.
 
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
 
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
 
Thanks. Just thought that formula SUM(A1:C1) can be added up with som
"complications" to avoid extra column or additional manual work
 
Back
Top