On Mar 8, 10:05 am, "Michael Laferriere" wrote:
I have a sheet that looks like this:
Jan Feb Mar Total
Rent 1000 1000 1000 3000
Utilities 500 500 500 1500

The Total column is calculated with the sum function. If I insert a column
to the left of the totals columns, then enter manually 1000 for Rent, the
formula recalculates to include the new column. Perfect! However, if I
"fill" the 1000 from the Mar column to the new column, the formula does not
recalculate. Odd! Any ideas why?

Just a hiccup in Excel's inductive algorithms. When you insert the
column, notice that the SUM range is not (yet) updated in the Total
column. Excel updates if you immediately manually enter a number into
the new column only because Excel ass-u-me-s that was your intent.
(It might not have been, in which case you probably would have written
a very different inquiry.) Apparently, Bill's Boys decided not to
take the same inductive leap when you do a "fill" or cut-and-paste.
Doesn't make sense? Go figure!

The way to do this reliably is to have a (hidden?) blank column just
to the left of the Total column and perhaps to the left of the Jan
column, and include the blank column(s) in the SUM range. Then, when
you insert a column, the SUM range is updated for good reason, whether
or not you enter a number in the new column.