View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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.