When I autosum a column I am getting an overcalculation, $65,388.28 which is
incorrect. The correct # is $63,827.50. This correct number is acheived by
adding each individual line. I received incorrect numbers all the way across
a row in each individual column. Almost as if some rows are hiding but they
aren't.

Very frustrating and I have had to go back and hand calc the reports to
verify #'s.

Thanks, Steph

check to make sure the autosum is selecting the whole range


"Steph" wrote:

When I autosum a column I am getting an overcalculation, $65,388.28 which is
incorrect. The correct # is $63,827.50. This correct number is acheived by
adding each individual line. I received incorrect numbers all the way across
a row in each individual column. Almost as if some rows are hiding but they
aren't.

Very frustrating and I have had to go back and hand calc the reports to
verify #'s.

Thanks, Steph

"Steph" wrote:
When I autosum a column I am getting an
overcalculation, $65,388.28 which is
incorrect. The correct # is $63,827.50.

It is very difficult to debug such problems at arm's length. If you wish,
send me the workbook at joeu2004 "at" hotmail.com, or otherwise make the
workbook publicly available.

Shot in the dark: if you are summing at least 3186 numbers, all derived
from formulas, perhaps you need to explicitly round each formula. If you
have an average calculation "error" (due to your failure to round) of about
$0.0049, it can add up to the difference that you see. Seems unlikely; but
that's the second thing that comes to mind.

(The first thing is hidden rows. But you assert there is none.)


----- original message -----

"Steph" wrote:
When I autosum a column I am getting an overcalculation, $65,388.28 which is
incorrect. The correct # is $63,827.50. This correct number is acheived by
adding each individual line. I received incorrect numbers all the way across
a row in each individual column. Almost as if some rows are hiding but they
aren't.

Very frustrating and I have had to go back and hand calc the reports to
verify #'s.

Thanks, Steph