Count if cell contians ... when cells may have more than one character

[Biking Loki]

In one column (I10:I489) of a spreadsheet, the cells may contain S , SW, SM, or M. I am looking for a formula that will count the number of cells that contain "S".

I've looked at previous post about this, but haven't found anything yet that works like it should.

TIA!

 

[Jonmo1]

Try this....

=COUNTIF(I10:I489,"*S*")

Hope this helps..

 

[Biking Loki]

Short, simple, and too the point. Thanks for the quick reply!