Re: [libreoffice-users] Simple sum in column getting zero in libreoffice calc 5.

Ok; having seen the file from a direct message, the problem is way simpler
than a formatting/data type problem :)

The SUM() function works to add values from cells. The problem is that you
have something in your cell that is not *a* number (things like
"3,94,700"). There is no way (that I know of...) to interpret that as a
number, so it is seen as a string.

Since the sample file seems to have three values in each cell, I assume
that the goal is to sum multiple tuples of "x,y,z" to get, in the end, the
sum of three series of values.
You can (and should...) put each group of values in separate columns and
sum them separately.

If your input data comes from a CSV file, make sure that the comma is used
as a separator, so the input gets split into separate columns. It is the
best course of action IMO; if you need the output in a specific format it
is always possible to merge the results.

I upload the sample file so people can get a look at it:
https://www.dropbox.com/s/qm03gjw3wwlpby9/example.ods?dl=0

Anything more would require knowledge of where your input comes from, or
what kind of output you need.

-- 
Cley Faye
http://cleyfaye.net

2016-05-12 7:46 GMT+02:00 Cor Nouws <oolst@nouenoff.nl>:

> Hi,
>
> Piet van Oostrum wrote on 12-05-16 00:40:
>
> > > Now non-plussed how to tell libreoffice to tell it to treat them
> > > as 'real numbers' ?
> >
> > One way you can get numbers as text is when you import a CSV file,
> > ....
>
> This is another option:
>
> http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates
>
> Kind regards,
> Cor
>
> --
> Cor Nouws
> GPD key ID: 0xB13480A6 - 591A 30A7 36A0 CE3C 3D28  A038 E49D 7365 B134 80A6
> - vrijwilliger http://nl.libreoffice.org
> - volunteer http://www.libreoffice.org
> - The Document Foundation Membership Committee Member
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted