Auto sum formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1873897%22%20slang%3D%22en-US%22%3EAuto%20sum%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1873897%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20inserting%20a%20row%20directly%20above%20the%20row%20with%20my%20auto%20sum%20formula%20in%20it%2C%20how%20do%20I%20make%20the%20auto%20sum%20formula%20change%20to%20include%20the%20new%20inserted%20row%20as%20part%20of%20the%20auto%20sum%20formula%3F%3C%2FP%3E%3CP%3EI%20know%20the%20auto%20sum%20formula%20changes%20if%20I%20insert%20a%20row%20above%20the%20final%20row%20in%20the%20auto%20sum%20formula%20but%20it%20doesn't%20seem%20to%20change%20when%20I%20insert%20the%20row%20directly%20above%20the%20auto%20sum%20row.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1873897%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1873939%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20sum%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1873939%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F864493%22%20target%3D%22_blank%22%3E%40stoshkorn%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20sounds%20like%20your%20SUM%20formula%20does%20not%20include%20the%20newly%20added%20row%20in%20it's%20range.%20You%20likely%20require%20a%20dynamic%20formula.%20Perhaps%20you%20could%20share%20a%20sample%20workbook%20that%20shows%20where%20you%20are%20running%20into%20an%20issue%20with%20your%20formula%3F%20(Please%20remove%20any%20sensitive%20information).%20This%20way%20I%20could%20give%20you%20a%20more%20specific%20solution.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 Replies

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.

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