CORRECTING ERROR IN A SUM FORMULA
 

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.

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.

CORRECTING ERROR IN A SUM FORMULA
 

Bob is probably correct. If you need more information, consult
http://www.mcgimpsey.com/excel/pennyoff.html

Jerry

"Bob Phillips" wrote:

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.