Auto sum formula

[stoshkorn]

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. 

[#2]

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.

[#3]

@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))