I'm making a spreadsheet of my daily expenses. My rows are populated with items I purchase such as gas, food, etc. My columns are each day of the month.
I autosum each row, and that total gets autosummed down the column to arrive at total expenses for the month.
Occasionally I insert a new row because I think of a new item I want to include. However, this causes a gap at the end of the row where the autosum usually is. It's not the biggest deal, but I then have to manually drag the bottom right corner of the cell above it to copy the autosum formula down to the new row inserted.
Is there a way where this can dynamically update, and I don't have to keep manually fixing the autosum for each new row inserted?
Bookmarks