CORRECTING ERROR IN A SUM FORMULA
Probably due to the figures showing rounded, but the real values being not
rounded. Try rounding all the amounts
=ROUND(A1,2)
or SUM the result rounded
=SUM(ROUND(D1:D9,2))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"BBGSIS" wrote in message
...
MY SUM OF A COLUMN OF CELLS IS OFF BY A FEW CENTS (EACH CELL CONSISTS OF A
CALULATION). I HAVE TO MANUALLY ADD THE COLUMN TO VERIFY IF IT IS OFF OR
NOT
AND IT ALWAYS IS BY A FEW CENTS.
|