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

The SUM() function adjust automatically when inserting in the middle. 
But, you have to be careful if you're inserting at the end of range, ie. 
before B1 or after B10.  If you're inserting B11, then SUM(B1:B10) stays 
the same, and shows in B12 now.

On 2026-03-31 06:34, Luis Iglesias wrote:
> Hi!
> I apologize if I haven't understood your problem.
> 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.
>
> Luis Iglesias
>
> ----- Mensaje original -----
> > De: "Chris Green" <cl@isbd.net>
> > Para: "users" <users@global.libreoffice.org>
> > Enviados: Martes, 31 de Marzo 2026 9:44:34
> > Asunto: [libreoffice-users] How to get column total in last row in calc?
>
> > One would have thought this was an easiy answered question but I can't
> > find a straightforward answer anywhere.
> >
> > If I have a spreadsheet with a column containing numbers how do I get
> > the sum of all the numbers in the column and put it in the last row?
> >
> > Yes, I know the obvious answer, if it's column B and I have ten rows
> > in my spreadsheet then the answer is:-
> >
> >     SUM(B1:B10)
> >
> > However this would need to be changed every time I add a row to the
> > spreadsheet.  There is surely a way of specifying 'the row before this
> > one' as the second parameter but I can't find how to do this.  It's so
> > basic that one would have thought a quick web search would provide the
> > answer but I've failed miserably to find it (maybe my searching
> > ability is poor).
> >
> > So, how do I specify 'the row before this one'?
> >
> > --
> > Chris Green
> >
> > --
> > 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


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