I'm using an online third-party form to collect data, that data gets submitted to Google Sheets. I applied a sum formula to calculate the sum of a column =SUM(A2:A50)
. A1
is used for header. Now, when the data comes in into Google Sheets, a new row gets created, and Google Sheets updates my formula automatically to only calculate rows =SUM(A3:A51)
skipping row A2
. Is there anyway to prevent Google Sheets from meddling with my formula?
Google-sheets – Adding row to Google Sheets updates SUM formula – I don’t want this
formulasgoogle sheets
Related Topic
- Google Sheets – Forms Data Manipulation
- Google Sheets – How to Autofill a Formula from Column to Row
- Google-sheets – Increment the reference to a cell formula by 1 in Google Sheets
- Google-sheets – Using DSUM in Google Sheets to sum recent data
- Google Sheets – Find Value of Last Non-Blank Cell in Row
- Google-sheets – Moving Rows of Google Form Responses to a new Sheet based on a specific answer in a column
- Google Sheets – How to Automatically Match Text Responses to Numbers and Sum
Best Answer
Basically I fixed the problem by simply doing a generic sum formula
This way no matter if new rows are created or subtracted the formula stays the same.