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.
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: =sum isn’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 cell A1 through cell A10
Ok I got it : press sum not write it… Sorry I need sleep ! ^^
Thanks !
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 @anon73440385 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.