New answers tagged spreadsheet
agtover's comment to the question works fine: Extend the function range to D3 (where the 'Amount' headline is), and then whenever a new row is added, only the end of the function range is updated.
You are using relative reference, which allows the sheet to assume you want to keep the range size the same, just move it. To keep it anchored, you need to use absolute referencing in your formula. This keeps it from moving. =SUM(D$4:D101) Using the $ before the 4 tells it to lock the top of the range to the 4th cell.
The service offered by ragic.com allows you to hide different fields or make them read only, and has many ways of configuring user access rights.
You can do this using the copyDown add-on by filling in the right formula in line 2. You can find the copyDown add-on here: https://chrome.google.com/webstore/detail/copydown/lipbbdpmkcbplmfnbholpabinnnkbbda
Top 50 recent answers are included