that has nothing to do with it, you should make sure the numbers are
formatted as numbers/general but you still might have force them to
calculate, copy an empty cell, select the numbers and do editpaste special
and select add, if that does not work you must have trailing invisible
characters like html line feed (Chr 160) or spaces. the green triangle most
likely indicate that it is text numbers so the method copying a cell and
paste special selecting add should work. Also make sure you have
calculations set as automatic under toolsoptionscalculation


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"dyfrog" wrote in message
...
Thank you gjcase, but the column is already formatted a NUMBER (not text)
but
still wont SUM.

Any other suggestions ?

"gjcase" wrote:


Make sure you have numbers vs text. There are numerous posts in this
forum on this subject. (Youn can test using ISTEXT)

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile:
http://www.excelforum.com/member.php...o&userid=26061
View this thread:
http://www.excelforum.com/showthread...hreadid=528373