What if there are blanks in the range?

"bgcooker" wrote:

I need to sum a range of cells that will contain both text and numbers. The
text will always be an "s" and the number will be a number between .25 and
10. The entry in the cells to be counted will be entered as "s.25" or
"s.5.5", and the number following the "s." needs to be totaled.

Is there a way to accomplish this using the COUNTIF or SUM functions?