My autosum total is incorrect - what is wrong?

G

Guest

I'm doing a basic formula - about 400 entries to tota. I used autosum and my
total is incorrect. Is there a way to figure out if these cells are
formatted as text and therefore not being read?
 
G

Gord Dibben

In an adjacent column enter =ISNUMBER(cellref)

Copy down.

Or without checking first you can format all as General.

Copy an empty cell and select the data and Edit>Paste Special>Add>OK>Esc.

This should turn any text to numeric.


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

Similar Threads

Formula not working 1
How do I make AutoSum really Sum, not Subtotal 5
AutoSum Value Incorrect 1
Hmm Still stuck 6
Formatting Cells/Data 1
Find/Replace Numbers stored as Text drops zeros 1
Countif result problem 4
Excel formula for adding up sub-totals in time format 2

Top