View Single Post
  #4   Report Post  
BMarilyn92220
 
Posts: n/a
Default Excel columns do not add correctly.

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

"Duke Carey" wrote:

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.

"BMarilyn92220" wrote:

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!