Re: [libreoffice-users] How to get column total in last row in calc?

At 12:34 31/03/2026 +0200, Luis Iglesias wrote:
> Assuming the initial case, where you have 10 rows of data, whether 
> you insert a whole row or insert a cell by selecting the option to 
> shift cells down, the formula will automatically change to
> SUM(B1:B11) or whatever.

Note that for this to be true there needs to be a tick at Tools | 
Options | LibreOffice Calc | General | Expand references when new 
columns/rows are inserted.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy