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