Consider this UDF:

Function zum() As Variant
Application.Volatile
With Application.Caller
zum = .Offset(0, -4) + .Offset(0, -3) + .Offset(0, -2) + .Offset(0, -1)
End With
End Function

It will always sum the four cells to the immediate left of the cell
containing the function.
--
Gary''s Student - gsnu200758


"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