count text

[C.S.]

hey guys,

range: B3:B17

contents of B3: "Johnson, Chris RB TEN"

I'm looking for a formula to count the number of times RB shows up in the specified range.

 

[Jonmo1]

Perhaps

=COUNTIF(B3:B17,"*RB*")

However, this will not distinguish between your example "Cris RB TEN" and say "Carbohydrte" or "Curb" or "Herb" etc...

is RB always by itself, with a space before and after?

If so this would work

=COUNTIF(B3:B17,"* RB *")

Notice the spaces.

 

[VoG]

Try

=COUNTIF(B3:B17,"*RB*")

 

[C.S.]

yup, the "* RB *" works like a charm. Thanks fellas.