Excel columns do not add correctly.

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!
 
G

Guest

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.
 
G

Guest

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.
 
G

Guest

Thank you, BJ, and Duke! I tried the array formula and it comes out correct.
You are much appreciated!!!
 

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

How do I make AutoSum really Sum, not Subtotal 5
Autosum will not update when I add new data. 3
Excel - the sums are not automatically calculating 2
How do I create autosum formula to show totals for visible data on 2
Excel is totaling wrong 1
Excel formula for adding up sub-totals in time format 2
calculaton and accuracy issue 2
Calc sometimes off by a penny 5

Top