AUTOSUM Coming up with an incorrect total

**ESCIV** · Jun 11th, 2003, 10:36 AM

This is certainly a new one for me -- I have a simple worksheet - first two columns are monthly charges - the third column I have a formula to add the first two columns and multiply by the tax rate for the county in question. The fourth column adds the three amounts across. At the bottom of the spreadsheet I am adding the amounts in each column, but three of the columns have incorrect amounts! I have check the format - they are all currency. I have tried manually typing =sum etc - no matter how I try it the amounts in those three columns are wrong. What else can I check? Thanks!

**Aladin Akyurek** · Jun 11th, 2003, 10:38 AM

Care to post the SUM formula?

**ESCIV** · Jun 11th, 2003, 10:59 AM

=(B126+C126)*0.0725 (for the tax amount)
=SUM(E2:E126) (for the bottom of the column)

nothing fancy as you can see.

**Aladin Akyurek** · Jun 11th, 2003, 12:12 PM

Originally Posted by ESCIV

=(B126+C126)*0.0725 (for the tax amount)
=SUM(E2:E126) (for the bottom of the column)

nothing fancy as you can see.

Compare the result of

=SUMPRODUCT(E2:E126+0)

with the result of

=SUM(E2:E126)

Any difference?

**ESCIV** · Jul 22nd, 2003, 02:36 PM

Thanks but no - I just had to two these 2 monthly reports again and the same thing has happened - I'm off by pennies, but the total must be exact.

**IML** · Jul 22nd, 2003, 02:40 PM

Does it look better if you click "precision as displayed" under tools, option, calculation.

**Joe4** · Jul 22nd, 2003, 03:05 PM

There are probably some rounding issues going on. Check out IML's response. Personally, I usually use the round function to make sure that everything is rounded off to the nearest penny to avoid problems:

=ROUND((B126+C126)*0.0725,2)

Keep in mind that what is displayed on the speadsheet is not always the actual content in the cell!

**ESCIV** · Jul 29th, 2003, 04:03 PM

You are awesome!! Thank you so much! I never knew what that "precision as displayed" was for! I can keep the rest of my hair on my head now! God bless!

**just_jon** · Jul 29th, 2003, 04:07 PM

Please be aware that the Precision as Displayed utility ewill, upon saving, permanently alter your underlying data. It will do so for the entire workbook, not just the sheet/cell in question.