"Carol A" wrote:
One group of numbers were being summed and the other were
a different calculation with a different result because of slight
rounding differences.

So if you still wonder why ("problem with Excel rounding numbers") and would
like an explanation, it would be helpful if you posted at least the two
different formulas, as well as how you have the option "Precision as
displayed" set. It would also be helpful to know the numbers involved.


----- original message -----

"Carol A" wrote in message
...
Thank you Joel. That was a good idea. That wasn't what was wrong but it
made me look at something else. One group of numbers were being summed
and
the other were a different calculation with a different result because of
slight rounding differences.

"Joel" wrote:

Maybe you have some hidden rows. Use =countA(A1:A100) on both worksheets
and
see if you are adding the same number of items.

"Carol A" wrote:

I have entered the exact same data into two different Excel worksheets
and am
getting a different total in each when calculated. The cells are
formatted
as Numbers, no decimal with separator. In one place the result is
41,660 and
the other is 41,657. Any ideas, help is appreciated.