Using Autosum

S

sjrobards

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.
 
S

sjrobards

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: $ -
 
D

Dave Peterson

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).
 
G

Gord Dibben

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 Edit>Paste Special>Add>OK>Esc.

Now do you get a SUM?


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top