It's rounding. When you see 67.42 in a cell, the actual value may be 67.416.
Excel rounds this to 67.42 because you asked for 2 decimal places to
display, but still uses 67.416 in the Sum calculation. When you have more
than one cell like this, your results are off by a penny.

To fix the error, put =round(...,2) around your formulas.

Regards,
Fred

"Access Joe" wrote in message
...
Hey everyone. Excel 2003.

I will frequently add up a range of cells (all dollar amounts that were
typed in manually). When I add those numbers up with the calculator,
let's
say they equal $1865.60. Then when I take them and put the same exact
numbers into a Column and do an autosum, the number comes up $1865.60.
GREAT!

But when I do an =SUM(... and then highlight the cells containing the same
numbers, the total come up $1865.59 (one penny off). Of course, it's not
all
the time. But I've noticed a difference sometimes between AutoSum and
manually entering a forumla (usually by just a penny). Why is this
happening
and how can I fix this before I loose my mind? Any help would be
appreciated. THANKS!