Forum Discussion
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...
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))