The OP said that he wanted to always sum 4 columns to the left.

I don't understand your comment.

xrelanon wrote:

Offset assumes you know how many columns there are going to be. You will have
to change it every time you insert a column which at that point, you may as
well reselect the SUM function range as it will be faster to do.
--
Gnothi se auton.

"Dave Peterson" wrote:

If the cell that contains the formula is E1, then one way:
=SUM(OFFSET(E1,0,-4,1,4))



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

--

Dave Peterson


--

Dave Peterson