View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beege
 
Posts: n/a
Default Sum help this is puzzling???????????

Scott

I don't get it. I copied/pasted your numbers into excel, came up with 49.607

Tools/Options/precision as displayed not checked.

Formatted as "general"

What formulas are you using to get the number in the column, and what
formula add them for you?

Beege


"scott" wrote in message
...
I have a simple sum problem. I have the following data entered. The sum
total
in excel =49.604
When you add these up it should read 49.607
What the heck is going on?
Scott
1.802
2.337
1.942
1.330
0.885
1.910
1.780
2.927
2.413
2.617
1.297
0.522
2.453
2.582
2.388
1.453
1.751
0.794
0.769
2.170
1.689
2.391
2.007
1.265
1.081
0.821
1.761
2.470
0.000
0.000
0.000