I can’t get auto sum to work. I have the same problem with plan maker also. probably would have the same problem with excel. I’ve tried everything. I’ve read the topic replies also. Please advise.
Show/upload an example and tell precisely what you expect to happen. Otherwise we start polishing our crystal-balls for better clairvoyance…
$68.45
$68.45
$68.45
$68.45
$68.45
$68.45
$68.45
$68.00
$68.00
$68.45
0
This is what I get a zero and not the sum of this range. Thanks.
I expected more an odc-file, but in this case I assume your cells contain no numbers, but text. An intelligent person can easily make the transformation, but a “less intelligent” piece of software needs help.
.
Try with a copy of your file: Mark the cells and use search and replace to search for $ and replace with nothing.
After this your cells should be flushed to the right border (typical standard for numbers). Otherwise mark the cells again and select text-in-columns from menu data.
PS: I edited your title to reflect your actual problem…
$68.45
$68.45
$68.45
$68.45
$68.45
$68.45
$68.45
$68.00
$68.00
$68.45
$0.00
The numbers are to the right. There were no letters. This is the formula used =SUM(H68:H77) when I hit enter it enters a 0. Thanks for your help
Your locale probably doesn’t use the $ character as currency symbol so the input resulted in text that needs to be converted to proper numeric cell content. Select/mark data and invoke Find&Replace (Ctrl+H)
- Find:
^\$(.+) - Replace:
$1 - Other options:
- ✓ Current selection only
- ✓ Regular expressions
Hit ReplaceAll.
See also this FAQ.
Please upload the .ods-file. Webcan’t even see, If your data is in H68:H77, but I hope you could check this yourself…
Thanks I’ll look at the faq