| View previous topic :: View next topic |
| 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 |
|
| Back to top |
|
 |
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. |
|
| Back to top |
|
|
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: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 |
|
| Back to top |
|
|
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 |
|
| Back to top |
|
|
|
