Incorrect SUM

[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

 

[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

 

[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

 

[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?

 

[Dave Peterson]

Was calculation set for manual?

This was a test, wasn't it?

 

[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