Using Offset Function where Column Changes

[HowardC]

I would like to use the offset function as follows

Each Month a new column will be Inserted in Column V

I need to sum data starting three columns to the right of column V and then two column to the right of that plus BC15 (this will also change each time a column is inserted in Col V

I have used a sum formula before inserting a new column showing you what i am trying to achieve

Your assistance will be most appreciated

Howard

[pieterse]

Use this formula instead of yours:

=SUM(OFFSET(T15;0;4;1;3))+BC15

It will ensure the sum keeps pointing to the same columns, regardless whether you insert columns.