Extend formula when adding a column

[excelingtoexcel]

I am trying to see if there is a way existing formulas can include any new columns i add. I have attached a sample workbook. Essentially, i want to add a new column before column G and i want column G, which has the formulas to include the values i enter in the new column so that i dont have to manually update the formulas daily. I have included the formulas i have configured in column G into column H for ease of visibility.

[Pete_UK]

You could change the formula in G3 to this:

=SUM(C3:INDEX(A3:G3,COLUMN(G3)-1))

then if you insert a new column G the formula (now in H3) will include the new column.

Hope this helps.

Pete

[excelingtoexcel]

yes!! this worked! thank you so much!

[Pete_UK]

Glad to be of help.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

[excelingtoexcel]

Thank you for sharing that info.