| View previous topic :: View next topic |
| Author |
Message |
kamoffice
Newbie
Joined: 07 Jun 2009
Posts: 1
|
 Posted: Sun Jun 07, 2009 10:53 pm Post subject: Cannot add right when read excel by calc |
 |
|
| I have an excel file, but when I open with calc, the sumation total is not correct. Please help me find out why and how to correct? [/list] |
|
| Back to top |
|
 |
mushtaque_asghar
General User
Joined: 07 May 2009
Posts: 40
Location: Islamabad, Pakistan
|
| Posted: Sun Jun 07, 2009 11:01 pm Post subject: Re: Cannot add right when read excel by calc |
|
|
Can you please tell me how are seeing the formula in actual sheet. The correct ways to write sum function are:
1. SUM(A1:A10)
2. SUM(A1;A2;A3;A4;A5;A6;A7;A8;A9;A10)
3. SUM(A1;A2;B1:B10)
Use Semi-colon instead of Comma in the formula.
_________________
Thanks & Regards,
Mushtaque Asghar
http://www.mushtaq4u.tk |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
|
| Back to top |
|
|
|
