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