# AUTOSUM Coming up with an incorrect total

This is a discussion on AUTOSUM Coming up with an incorrect total within the Excel Questions forums, part of the Question Forums category; This is certainly a new one for me -- I have a simple worksheet - first two columns are monthly ...

1. ## AUTOSUM Coming up with an incorrect total

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!

2. ## Re: AUTOSUM Coming up with an incorrect total

Care to post the SUM formula?

3. ## Re: AUTOSUM Coming up with an incorrect total

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

nothing fancy as you can see.

4. ## Re: AUTOSUM Coming up with an incorrect total

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?

5. ## Re: AUTOSUM Coming up with an incorrect total

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.

6. ## Re: AUTOSUM Coming up with an incorrect total

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

7. ## Re: AUTOSUM Coming up with an incorrect total

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!

8. ## Re: AUTOSUM Coming up with an incorrect total

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!

9. ## Re: AUTOSUM Coming up with an incorrect total

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.

10. ## Re: AUTOSUM Coming up with an incorrect total

Another reason the autosum and the sum shown in the bottom right status bar in Excel do not match could be because you have hidden rows!

The "sum of selected cells" only uses visible cells

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•