Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Autosum
When I use the autosum icon on the toolbar to add contiguous rows in one
column, I just get a dash and a dollar sign. I can't get it to compute the sum. -- sjrobards |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Autosum
Is the column wide enough?
"sjrobards" wrote: When I use the autosum icon on the toolbar to add contiguous rows in one column, I just get a dash and a dollar sign. I can't get it to compute the sum. -- sjrobards |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Autosum
Yes, that's not it. I tried widening it. Anyway, you get a group of ####
signs when the column isn't wide enough. I just get this: $ - -- sjrobards "June Bug" wrote: Is the column wide enough? "sjrobards" wrote: When I use the autosum icon on the toolbar to add contiguous rows in one column, I just get a dash and a dollar sign. I can't get it to compute the sum. -- sjrobards |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Autosum
That's the accounting (or currency) format.
You'll see that if the cell's value is 0. Format the cell in some other way (General???) (and keep the columnwidth wide). sjrobards wrote: Yes, that's not it. I tried widening it. Anyway, you get a group of #### signs when the column isn't wide enough. I just get this: $ - -- sjrobards "June Bug" wrote: Is the column wide enough? "sjrobards" wrote: When I use the autosum icon on the toolbar to add contiguous rows in one column, I just get a dash and a dollar sign. I can't get it to compute the sum. -- sjrobards -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Autosum
Your cells are formatted to Accounting Style and your total is zero.
Sounds like the "numbers" are not real numbers. Format all to general. Copy an empty cell. Select the range of numbers and EditPaste SpecialAddOKEsc. Now do you get a SUM? Gord Dibben MS Excel MVP On Wed, 7 Oct 2009 12:10:04 -0700, sjrobards wrote: When I use the autosum icon on the toolbar to add contiguous rows in one column, I just get a dash and a dollar sign. I can't get it to compute the sum. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autosum | Excel Discussion (Misc queries) | |||
AutoSum | New Users to Excel | |||
how do i set up autosum as a % | Excel Worksheet Functions | |||
autosum | Excel Worksheet Functions | |||
AutoSum | Excel Worksheet Functions |