Excel columns do not add correctly.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The column totals with both AutoSum and manually entered formula are off
(low) by 2 to 3 cents. There are no formula errors. I do not see where any
figures are being rounded.
I NEED HELP!
 
If your data is calculated, it probably is rounding.
change your column to show at least 4 or 5 decimal places
then look for rounding.

you may need to formally round off the data to the precision you want.
 
To confirm BJ's assertion that rounding IS the issue, see if the SUM() you
are getting matches what you would get by using this array formula - meaning
you have to enter it by pressing Shift+Ctrl+Enter

=SUM(ROUND(data range,2))

If the above formula gives you the value you expect, then you're going to
need to have to deal with rounding the values.
 
Thank you, BJ, and Duke! I tried the array formula and it comes out correct.
You are much appreciated!!!
 
You must log in or register to reply here.

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

Autosum will not update when I add new data. 3
Excel is totaling wrong 1
Autogroup then sum - can it be done? 5
Calc sometimes off by a penny 5
AUTOSUM WON'T CALCULATE 3
Why is AutoSum iinoperable w/protection when column is unlocked? 2
Excel - the sums are not automatically calculating 2
SUM formula in Excel2007 5

Back
Top