Google-sheets – Adding row to Google Sheets updates SUM formula – I don’t want this

formulasgoogle sheets

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?

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.