To confirm BJ's assertion that rounding IS the issue, see if the SUM() you
are getting matches what you would get by using this array formula - meaning
you have to enter it by pressing Shift+Ctrl+Enter

=SUM(ROUND(data range,2))

If the above formula gives you the value you expect, then you're going to
need to have to deal with rounding the values.

"BMarilyn92220" wrote:

The column totals with both AutoSum and manually entered formula are off
(low) by 2 to 3 cents. There are no formula errors. I do not see where any
figures are being rounded.
I NEED HELP!