Incorrect SUM

D

Dave B

All of a sudden, my Excel can't add two identical columns and get the same
answer. Quadruple checked, started over numerous times (won't tell you how
long it took to figure out what the problem was.) Very simple spreadsheet.

Any thoughts?

Dave B
 
J

Jerry W. Lewis

Likely some of the "numbers" in one of the column are actually text
instead of numbers. Compare COUNT() of the two columns. To convert
text to a number, copy an empty cell, select the data range and
Edit|Paste Special|Add.

Jerry
 
G

Gord Dibben

Dave

How far out are the calculations?

Could a value or two be text? Check with =ISTEXT(cell) or =ISNUMBER(cell)

Are values derived from formulas?

Any ROUNDing taking place?

Browse through the postings in this google search thread to find some answers.

"Excel can't do math!"

http://snurl.com/35xt

Gord Dibben XL2002
 
D

Dave Peterson

Numbers formatted as text.
hidden rows
numbers that looked the same on the worksheet, but were actually different
values.

What was the problem/solution?
 
D

Dave B

Dave
No, it wasn't a test. (Good idea, though!) It was, however, text
formatting.
Thanks all, much appreciated.
And after all these years-

Dave B
 
Top