Li Wei wrote: > I have attach the calc file, it's in Chinese, (sorry) > my question is how to display sum(N1:N8) in cell N9
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.
