Will add, won't sum?

D

dlw

I copied some numbers from an Access query into an Excel 2000 spreadsheet.
When you sum them, it comes up 0, when you just add them, it works. For
example =(a1+a2) gives the right answer, =sum(a1.a2) gives 0.
What causes that?
 
R

RichardSchollar

Hi

Excel is recognising the cells as Text rather than as numeric values -
the addition operator coerces Excel to recognise the numbers as
genuine numerics and hence this works. Sum on the other hand ignores
text (ie so no coeceion takes place). Potentially you can convert
these 'numbers' back to text by selecting the entire column and going
Data>TextToColumns and clicking Finish.

Hope this helps!

Richard
 
T

Teethless mama

Your data are Text value so it won't work with =SUM(A1:A2)
you can get around with Sum function with this =SUM(--A1,--A2)
 
D

dlw

Yes, they were text, it was throwing me off, because in addition to adding
them, it also formatted this "text" as currency and numbers with 0 decimal
places.
(very coercive)
 
P

PCB

I had this same problem, but nothing I try will convert the "text" to
numbers. Any other ideas?
 
Top