Re: how to sum a column in openoffice calc
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.
Reply to: