Incorrect SUM

  • Thread starter Thread starter Dave B
  • Start date Start date
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
 
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
 
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
 
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
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
 
Back
Top