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 <[email protected]>: > 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: [email protected] > 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: [email protected] 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
