Add a range of cells with labels in Calc

I am making a spread sheet and am trying to figure out how to create a formula to add a column of cells. The column has labels as well as money values. I need to be able to add and delete cells and have the formula update every time I add and remove cells. If I remove cells then the column moves up. If I add cells the column moves down.

There is an option under ‘Tools’ > ‘Options’ (‘Preferences’ on Mac) > ‘LibreOffice Calc’ > ‘Calculate’ labeled “Automatically find column and row labels”.

If you choose this option and your column label, say MyData, is contiguously preceding the values which also are assured to be contiguous a formula like =SUM(MyData) should work and update automatically. From my sparse experience (I rarely use such automatisms) I suspect it does not under any circumstances update correctly on the fly. The constructs I use for the purpose are not easily described in a few words.)