Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > linux.debian.user > #157991

Re: how to sum a column in openoffice calc

Show all headers | View raw

Op Wed, 16 Sep 2015 23:13:34 +0200 schreef Li Wei <rootof3@yahoo.com>:

> Thanks to all those who reply!
>
> I have prefix equal sign, but it doesn't work
> I have attach the calc file, it's in Chinese, (sorry)
> my question is how to display sum(N1:N8) in cell N9
>
> Thanks!
>


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

Success,

floris

Back to linux.debian.user | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Re: how to sum a column in openoffice calc Li Wei <rootof3@yahoo.com> - 2015-09-16 23:20 +0200
  Re: how to sum a column in openoffice calc Floris <jkfloris@dds.nl> - 2015-09-16 23:30 +0200
    Re: how to sum a column in openoffice calc Carl Fink <carl@finknetwork.com> - 2015-09-17 02:40 +0200
  Re: how to sum a column in openoffice calc Sven Arvidsson <sa@whiz.se> - 2015-09-17 16:40 +0200
  Re: how to sum a column in openoffice calc Siard <shiems146@kpnplanet.nl> - 2015-09-17 17:10 +0200
    Re: how to sum a column in openoffice calc Li Wei <rootof3@yahoo.com> - 2015-09-17 18:50 +0200
      Re: how to sum a column in openoffice calc Siard <shiems146@kpnplanet.nl> - 2015-09-17 22:40 +0200
      Re: how to sum a column in openoffice calc Curt <curty@free.fr> - 2015-09-18 14:10 +0200
        Re: how to sum a column in openoffice calc Li Wei <rootof3@yahoo.com> - 2015-09-18 23:40 +0200
          Re: how to sum a column in openoffice calc David Wright <deblis@lionunicorn.co.uk> - 2015-09-19 05:10 +0200
            (solved) Re: how to sum a column in openoffice calc Li Wei <rootof3@yahoo.com> - 2015-09-19 06:00 +0200

csiph-web