Use a mixed reference in your SUM function: =SUM($C2:F2), if columns C to F
are your 4 columns, always insert a new row before the last data column
(i.e., your 3rd column with 4 columns of data, the 4th column with 5 columns
of data etc.) and then you AutoFill the formula down to the remaining rows in
the last column...I am assuming you are summing.

The alternative is VBA where you make Excel look for a new column to the
left of the SUM column and then programatically change the range argument of
the SUM function in the 5th, 6th etc. column where you are summing.
--
Gnothi se auton.


"Mark" wrote:

How do I sum the adjacent 4 columns into a cell? I want an cell to always sum
the 4 cells to the left, allowing for me inserting a new column each week,
ie. a rolling answer.

Any help greatly appreciated.

Thanks