I NEED TO SUM NUMBERS ON A COLUMN THAT HAVE TEXT AND NUMBERS

[Guest]

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

 

[Peo Sjoblom]

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

 

[Bernard Liengme]

Try =SUM(IF(ISERROR(C10:C13),0,C10:C13)
enter it as an array formal with CTRL+SHIFT+ENTER

 

[Peo Sjoblom]

Or

=SUMIF(C10:C13,"<>#VALUE!")

if the only errors are value errors

 

[Guest]

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.