Forum Discussion
stoshkorn
Nov 10, 2020Copper Contributor
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...
PReagan
Nov 10, 2020Bronze Contributor
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.