Autosum problems

S

Steph

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
 
J

Joe User

Steph said:
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 -----
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top