Re: how to sum a column in openoffice calc
On Wed, Sep 16, 2015 at 11:27:12PM +0200, Floris wrote:
> What is your decimal separator?
>
> Go to Tools --> Options --> language Settings --> Languages
>
> Because when I replace the dots, with a comma the formula
> =SUM(N1:N8) works
Interestingly, on my system the items in those cells are not numbers at all.
They're labels (text) that therefore add up to zero.
--
Carl Fink nitpicking@nitpicking.com
Read my blog at blog.nitpicking.com. Reviews! Observations!
Stupid mistakes you can correct!
Reply to: