Forum Discussion

stoshkorn's avatar
stoshkorn
Copper Contributor
Nov 10, 2020

Auto sum formula

When inserting a row directly above the row with my auto sum formula in it, how do I make the auto sum formula change to include the new inserted row as part of the auto sum formula?

I know the auto sum formula changes if I insert a row above the final row in the auto sum formula but it doesn't seem to change when I insert the row directly above the auto sum row. 

excel

2 Replies

  • JoeUser2004's avatar
    JoeUser2004
    Bronze Contributor
    Nov 10, 2020

    stoshkorn   First, there is nothing special about "autosum" per se.  "Autosum" simply describes a method for creating a SUM formula.  Suppose your existing formula in A101 is =SUM(A1:A100).  Change it to:

     

    =SUM(A1:INDEX(A:A,ROW()-1))

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Nov 10, 2020

    Hello stoshkorn,

     

    It sounds like your SUM formula does not include the newly added row in it's range. You likely require a dynamic formula. Perhaps you could share a sample workbook that shows where you are running into an issue with your formula? (Please remove any sensitive information). This way I could give you a more specific solution.

Resources