Are these numbers with decimals, by any chance?

The culprit it always the difference between the displayed values and the
values in the cells. So, you might see three cells that each show 1.02, that
would appear to sum to 3.06. However, the value in each of the cells is
1.017. When those are added the result is 3.05

You can either 1) use ROUND() function on each of the cells, 2) tell Excel
to display more decimals to allow you to see the true values


"Holden Caulfield" wrote:

I've been noticing that Excel 2003 is incorrectly adding up the numbers in a
column. Anyone know why this is and is there a fix for it?