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