Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Feb 2008
    Posts
    1,009
    Thanks
    63
    Thanked 2 Times in 2 Posts
    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
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •