In Google Sheets, when you sum a column in row A13, such as SUM(A3:A12), if you try to insert a row below A12, the Sum formula doesn't update to include A13. You do get a blank row, but the sum formula doesn't change. I prefer not to use "indirect" because that involves hard coding in the column letter, and I actually have about 60 columns with summary formulas. I'm not sure of the best solution. might you have any suggestions?
Solved by B. J. in 30 mins