So did you test if they were text using those formulas (you can also use
=ISTEXT(A1))


--


Regards,


Peo Sjoblom



"chelle" wrote in message
...
Yes I need to sum the values in column B
--
Chelle


"Peo Sjoblom" wrote:

Text maybe, what happens if you test the values with =ISNUMBER(A1)
=ISNUMBER(B1)
then copy down as long as needed to cover the values in A and B
if you get any false then you have text and I showed how you could
correct
that unless you want to sum the values as opposed to count them


--


Regards,


Peo Sjoblom