Ask Your Question

add a range of cells with lables in Calc

asked 2015-07-02 23:28:06 +0200

Steve7233 gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-07-03 10:16:40 +0200

Lupp gravatar image

updated 2015-07-03 22:57:32 +0200

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-07-02 23:28:06 +0200

Seen: 89 times

Last updated: Jul 03 '15