Let's see some example of the data and the result
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"bookscoffee" wrote in message
...
Has this happened to anyone else? When I use the SUM function either
auto
or manually the total result will be off by 1, sometimes 2. It is like
Excel
is rounding something. I'm using Excel 2000. I even tried starting all
over
with a new worksheet in a new workbook thinking the first workbook was
corrupted. But it seems that the addition glich is in all my workbooks.