I have not realized the problem is so difficult I'd rather do manual calculation, it's one-time task The file is paste from a Excel file
Thanks anyway! -------------------------------------------- On Thu, 9/17/15, Siard <shiems...@kpnplanet.nl> wrote: I can see it now. N1:N8 do not contain numbers; they contain alphanumeric strings. If you select N1, then this is what you see in the formula bar: '-755.68 The apostroph it starts with, shows that this string is alphanumeric. I don't know how you got those numbers there in the first place. There must be a better way. But there is a workaround. Insert a new column O (next to N) and put this formula in O1: =N1+0 (0 = zero) In LibreOffice, an addition like this converts the alphanumeric string into a number. Now copy O1 to O2:O8 and you'll see that SUM(O1:O8) in O9 works.
