[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
Guest

 Posted: Tue Apr 13, 2004 7:40 am    Post subject: SUM won't sum negativ numbers Hi I need to SUM positiv and negative numbers. Positiv numbers are OK. Bit SUM only adds positiv numbers. The Formula is: SUM(A1:A20)/10 nest row : SUM(A2:A21)/10 ... If all cells are positiv : restult is correct if some are positive ansd some negativ: only the positiv one added if all are negativ: result is = 0 Is this a bug or have I to do something diffeent? thank you
David
Super User

Joined: 24 Oct 2003
Posts: 5668
Location: Canada

Posted: Tue Apr 13, 2004 3:54 pm    Post subject: Re: SUM won't sum negativ numbers

 Anonymous wrote: Hi I need to SUM positiv and negative numbers. Positiv numbers are OK. Bit SUM only adds positiv numbers. The Formula is: SUM(A1:A20)/10 nest row : SUM(A2:A21)/10 ... If all cells are positiv : restult is correct if some are positive ansd some negativ: only the positiv one added if all are negativ: result is = 0

I for one seem to have no such problem. If it's a small spreadsheet, could you send it here for a better look?

David.
erikanderson3
OOo Advocate

Joined: 25 Feb 2004
Posts: 332
Location: San Francisco peninsula

Posted: Tue Apr 13, 2004 6:19 pm    Post subject:

Double-check that the cells are all formatted for Number. I cannot reproduce the behaviour on my install, but there may be a slim chance the negative numbers are being treated as text instead of numbers. If this is the case, selecting a cell with a negative number will likely show a single apostrophe before the number:
 Code: '-6
Furthermore, the alignment may be different. Numbers are usually right-justified, while text is left-justified. Format the cell as Number, hit Backspace to clear the contents, re-type the negative number, and it should sum correctly.

Also, what version of OOo are you using?

Cheers,

Erik
carl
Super User

Joined: 21 Apr 2003
Posts: 920
Location: Germany

 Posted: Tue Apr 13, 2004 9:50 pm    Post subject: try Edit> Value Highlghlt to check if the minus values are being read as numbers or text. I use File>Find and edit on selected columns to fiddle with removing dots and replacing with commas (or vice versa) Also you can remove unwanted or unreadable currency symbols , dr/cr signs etc._________________carl Using OpenOffice.org 2 on XP sp2
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group