sum returns name

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 ?



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

1 Like

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.