Another way is to name your data.
Type in a header (say data_f) at F2, put the cursor on
the bottom border of the cell
and SHIFT+double click left mouse.
This will select all the data in column F.
Insert Name Create Top Row
Change your formula to SUM(data_f)
If you insert or delete cells in your named range,
other than the top or bottom cell,
the named range adjusts automatically.
No need to change the formula.
Otherwise, rename the range with the above method,
or implement a dynamic range name. Search this group.
Tip: To move to the top or bottom of a range,
double click the top or bottom border of any cell.