Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I hope I am describing this accurately:

    Column M (April 2009)
    Column N (May 2009)
    Column O (formula) =SUM(N6-M6)

    For June, I copy Column N and insert it to the right of Column N (becoming Column O )
    Now Column P has the formula =SUM(N6-M6) which I have to manually change to =SUM(O6-N6)

    Is there an option where the formula automatically updates without manually having to change it?

    Thank you for your help.

    Michael

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You could use a formula like this in O6:

    =OFFSET(O6,0,-1)-OFFSET(O6,0,-2)

    This will always calculate the difference of the two cells to the left of the cell with the formula. Note that there is no need to use SUM.

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you Hans - EXACTLY what I was looking for.

    Michael

Posting Permissions

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