Using AutoSum Button results in miscalculations

[Twan]

I have a workbook that has a couple hundred worksheets in it and one o
the worksheets is pulling values (via formulas) to it from many of th
other sheets. Now, all the values have apparently pulled ove
correctly, but when I run an AutoSum totalling all of the values i
adds them incorrectly. I verified this by using a calculator and b
retyping all the numbers in the next column in the worksheet and usin
AutoSum to total those numbers.

What could cause this? Is there a rounding problem somewhere? I hav
double and triple checked my formulas and they are all correct. I jus
don't understand why the AutoSum would be off. BTW, it is only
couple pennies either way.

If that may be the problem, how could I resolve this

 

[Jim Rech]

One thing to be aware of is that Excel adds what is "really" in the cell
(but see below for an exception) instead of what appears in the cell. So
just to be sure you are adding the same thing as Excel, select the range of
numbers and do a Format, Cells, Number and pick General. Then you should
see, I would guess, a few more decimal places. These may account for the
seeming error.

If you select "Precision as Displayed" under Tools, Options, Calculation
then Excel uses what appears in the cell in its calculations. This setting
affects the entire workbook.
--
Jim Rech
Excel MVP
|I have a workbook that has a couple hundred worksheets in it and one of
| the worksheets is pulling values (via formulas) to it from many of the
| other sheets. Now, all the values have apparently pulled over
| correctly, but when I run an AutoSum totalling all of the values it
| adds them incorrectly. I verified this by using a calculator and by
| retyping all the numbers in the next column in the worksheet and using
| AutoSum to total those numbers.
|
| What could cause this? Is there a rounding problem somewhere? I have
| double and triple checked my formulas and they are all correct. I just
| don't understand why the AutoSum would be off. BTW, it is only a
| couple pennies either way.
|
| If that may be the problem, how could I resolve this?
|
|
| ---
|
|

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/rounding.htm