Ask Your Question

sum returns name

asked 2019-10-04 18:36:57 +0100

libre_max gravatar image

updated 2020-07-20 18:59:41 +0100

Alex Kemp gravatar image

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 ?



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.

edit retag flag offensive close merge delete


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.

Opaque gravatar imageOpaque ( 2019-10-04 18:56:47 +0100 )edit

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

Opaque gravatar imageOpaque ( 2019-10-04 19:14:03 +0100 )edit

Ok I got it : press sum not write it.. Sorry I need sleep ! ^^ Thanks !

libre_max gravatar imagelibre_max ( 2019-10-04 19:18:39 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-08-19 21:44:16 +0100

LeroyG gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-10-04 18:36:57 +0100

Seen: 540 times

Last updated: Aug 19 '20