Using AutoSum Button results in miscalculations

T

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
 
J

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?
|
|
| ---
| Message posted
|
 

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

Similar Threads

using symbols and numbers in the same formula 5
VLOOKUPS: Limits on # per sheet? 2
Vlookup Function returning #N/A error for two entries 2
move a row of data from one work sheet to another using a formula 1
copy font...not formatting 4
Simple subtraction formula returning strange results = Excel glitc 13
I need help creating a Bill of Lading using Excel. 0
OR Exact statement not working to compare values in two columns 4

Top