Thank You
I don't know what I was thinking. Your answer made me review what I was
doing. You were right. Thank you again.

"Peo Sjoblom" wrote:

No need to shout!
SUM will ignore text so if you get a value error you must have a value error
in A1:A20.


--

Regards,

Peo Sjoblom


"FORMULA" wrote in message
...
i NEED TO TOTAL A COLUMN THAT HAS TEXT AND NUMBERS.
i USED THE SUM(A1:A20) AND EXCEL GAVE ME VALUE
iS THERE ANY WAY TO DO THIS