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 In Google Sheets
- Google-sheets – How to autofill a formula referring to a column into a row on Google Sheets
- 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 a row (while skipping specific columns)
- 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 those numbers in Google Sheets/Forms

## 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.