+ Reply to Thread
Results 1 to 6 of 6

Help, When inserting a new row SUM ranges do not update.

  1. #1
    Registered User
    Join Date
    06-03-2013
    Location
    PE, Canada
    MS-Off Ver
    Excel 2003
    Posts
    2

    Help, When inserting a new row SUM ranges do not update.

    Good day,

    I seem to be having an issue with what I think should be an easy problem, but for the life of me I cannot find an answer.

    I am using Excel 2003.

    I have a column. D3-D7 have numbers in them and I want to add them. I put a formula in D8 to SUM all the Cells From D3-D7. No problems there.

    When I insert a row above D8 the range for the SUM is not expanding, and if I do put info in the cell a box comes up asking if I want to update the formula.

    Is there a way to insert a new row and have it be included in a range?

    please let me know if you need clarification.

    Thank you

  2. #2
    Forum Contributor
    Join Date
    02-28-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    272

    Re: Help, When inserting a new row SUM ranges do not update.

    Instead of inserting row above D8 insert the row between D3-D7
    Please consider adding a * if I helped

  3. #3
    Registered User
    Join Date
    06-03-2013
    Location
    PE, Canada
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Help, When inserting a new row SUM ranges do not update.

    That worked, thank you.

    That solves my "up and down problem" now I have the same issue but across columns. Example I am using "=PRODUCT(E3,H3)" on row 3. when I add a new row. The new row does not carry over the formula Eg. E4,H4. is there a way to do that?

  4. #4
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Help, When inserting a new row SUM ranges do not update.

    Hello
    An alternative using the Offset function:

    Please Login or Register  to view this content.
    Hope this helps
    DBY

  5. #5
    Forum Contributor
    Join Date
    02-28-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    272

    Re: Help, When inserting a new row SUM ranges do not update.

    DBY is right

  6. #6
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Help, When inserting a new row SUM ranges do not update.

    Hello
    The only way I know outside of using VBA is to convert your data to a 'List' if using Excel 2003. That way the formulas are added as you add more rows. But you won't be able to have the SUM at the bottom of each column.

    DBY

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1