I have a Google Spreadsheets in which I keep a list of expenses. I add a new expense by inserting a new row above the last expense. On the first row of the spreadsheet, I keep a sum of all expenses:
However, when I add a new row, the function range shifts down by one row to
=SUM(D5:D102), i.e. it is still covering the previous range of expenses, but I would like it to include the most recent one on line 4 as well:
As I add new rows quite often, I would like the spreadsheet to do this automatically.
Do you know how to achieve this?