| View previous topic :: View next topic |
| Author |
Message |
MsScarlet1957
Newbie
Joined: 05 Sep 2007
Posts: 3
Location: Ohio
|
 Posted: Wed Sep 05, 2007 5:38 am Post subject: Sum not working properly? |
 |
|
Hello, I am not extremely familiar with spreadsheet function, although I have used spreadsheets for years, just for keeping track of text items mostly,
I had Office 2.1 installed and all has been fine,
but last night I upgraded to 2.2.1
and when I opened a previous "working" calc file, the cell into which a "sum" did appear fine before, now only has ### in it.
I simply have =SUM(A3:A40) in cell D3
nothing complicated, and D3 is formated as a currency.
I have rebooted my puter after the install, not really sure what else to try to get this to work properly, need help |
|
| Back to top |
|
 |
Korak
OOo Enthusiast
Joined: 25 Sep 2004
Posts: 116
|
| Posted: Wed Sep 05, 2007 6:07 am Post subject: |
|
|
It looks like your column is not wide enough to show the number. Try widening it.
Scott |
|
| Back to top |
|
|
MsScarlet1957
Newbie
Joined: 05 Sep 2007
Posts: 3
Location: Ohio
|
| Posted: Wed Sep 05, 2007 6:19 am Post subject: |
|
|
| Korak wrote: | It looks like your column is not wide enough to show the number. Try widening it.
Scott |
Interesting! I did widen it, and now the actual formula appears.. =SUM(A1:A40)
and not what the total is of A1 to A40
I do have numbers in A1 to A15 so there "should" be a number there
And I might add when I click on the cell to check the fomat, it shows there what the actual total is that should be showing in the cell |
|
| Back to top |
|
|
Korak
OOo Enthusiast
Joined: 25 Sep 2004
Posts: 116
|
| Posted: Wed Sep 05, 2007 6:30 am Post subject: |
|
|
I am not sure, but is your autocalculate on?
Go to 'Tools->Cell Contents' and make sure that the Autocalculate is on.
Scott |
|
| Back to top |
|
|
huwg
Super User
Joined: 14 Feb 2007
Posts: 890
|
| Posted: Wed Sep 05, 2007 7:00 am Post subject: |
|
|
| Also check Tools > Options > Calc > View > Display > Formulas is OFF |
|
| Back to top |
|
|
MsScarlet1957
Newbie
Joined: 05 Sep 2007
Posts: 3
Location: Ohio
|
| Posted: Wed Sep 05, 2007 12:23 pm Post subject: |
|
|
| huwg wrote: | | Also check Tools > Options > Calc > View > Display > Formulas is OFF |
AHHH... there you go!
that was it!
once I unchecked the box in formula, the actual total showed up!
I wonder how that got checked to begin with!
Maybe it is a default setting, when you first install, I don't know.
But I am happy that all is fine now, and I sure thank you for helping me out!! |
|
| Back to top |
|
|
|
