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: [email protected]
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
