The most common cause of this is that some of the "numbers" are actually text.

Simply re-formatting will not help.

Re-format all to general then copy an empty cell.

Select the "numbers" and Editpaste SpecailAddOKEsc.

Excel should now treat those as real nunbers.


Gord Dibben MS Excel MVP

On Fri, 8 Sep 2006 12:43:02 -0700, Wendy
wrote:


I've been having the same kind of problem. One thing I've discovered is
that if some of the numbers in the cell is a sum of numbers in other columns,
and some of the numbers are numbers that I've indicated are 'equal to'
numbers in another column, or numbers that I've entered on my own, excel does
not include all of the numbers when I sum them

I've gone back and changed the summed totals by typing in that total and it
will work, but it's sure a pain. I've never run across this problem before
now when I've used Excel, so am not sure if there is something wrong with my
present software.


"Holden Caulfield" wrote:

I've been noticing that Excel 2003 is incorrectly adding up the numbers in a
column. Anyone know why this is and is there a fix for it?