Do you need the "CS" in the cell as part of the data? You may be able to
use a custom format to add the "CS" and have the cell itself just have
numbers.
"KL" wrote in message
...
you could possibly do this:
=SUM(SUBSTITUTE(A1,"cs",""),SUBSTITUTE(A2,"cs","") )
or even array entered (Ctrl+Shift+Enter):
=SUM(IF(ISNUMBER(--SUBSTITUTE(A1:A10,"cs","")),--SUBSTITUTE(A1:A10,"cs","")))
regards,
KL
"Ron" wrote in message
...
Is there any way to sum up cells if they contain text and letters. For
example I would like to sum up 6cs and 12cs for a total of 18.
Is there a function where I can make an If statement that would have a
condition such as endswith "cs"?
Thanks
|