If cells contain specific text the count

[habsfan]

Hi.
This has been driving me nuts.

CELLS AA5:AA64 will have either EF, CS, SBS and/or, RP.
Cell AA16 could be "EF / CS / SBS" and AA20 could be CS

I want Cell AA65 to count show how many CS's have been entered in that range. How would I do this.

Thanks in advance.

-A

[DonkeyOte]

If the criteria are all exclusive from one another (ie you don't have CS and CCS options) then a standard COUNTIF should suffice:

AA65: =COUNTIF(AA5:AA64,"*CS*")

[NBVC]

Try

=Countif(AA5:AA64,"*CS*")

[habsfan]

You guys rock. Thanks so much!