Hi Joel,
If the cells have been formatted after data entry, it could still be text.
In an adjacent column, test each cell with =ISTEXT(A2) (fill down)

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