Hi, I followed this documentation to get the sum of a column and the result cell return #NAME after I press "apply". How can I get the sum please ?
Thanks
LBO : 6.2.7.1
Edit : Sorry : I forgot to give the link to doc. The formula is =sum
I have a question I want to add : do ALL the cells selected MUST have a number in it ? Column is a match to a calendar column and not all days are defined yet.
The doc you give the link to is about sum in Writer tables: there you will see something like =sum<A1:A5>.
In Calc, =SUM without parentheses will show "#NAME?"; and =SUM() will show "0" (seem it is not useful).
Like the sample @Opaque wrote, you need to add some content to your function: numbers, references to cells or to cell ranges of numbers.
More LibreOffice Help on SUM function.
Asked: 2019-10-04 18:36:57 +0100
Seen: 540 times
Last updated: Aug 19 '20
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Please add at least your formula - otherwise the only advice that can be given is to read the Error Code Page - Scroll down to 525.
regarding your "Answer:
=sumisn't a valid formula. You don't tell the command (sum), which cells to sum. So it should look like=SUM(A1:A10), if you want to sum values in from cellA1through cellA10Ok I got it : press sum not write it.. Sorry I need sleep ! ^^ Thanks !