how do i create count formula for two items in same cell

[Curly Worly]

I am trying to count the number of times a particular set of letters (a
persons name abreviated) appears in a cell. I am using the count function.
However a particular cell has two sets of abreviated letters (JRD / GB). How
do I get the formula to recognise that both items need to be counted
independently, as normal "countif" is not recognising anything in the cell at
all

 

[Pete_UK]

You can use wildcard characters with COUNTIF, like this:

=COUNTIF(A:A,"*JRD*")

Hope this helps.

Pete

 

[Curly Worly]

Thanks it worked. I thought it would be something alot more complicated.
Thanks for your help

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Thanks it worked.  I thought it would be something alot more complicated..  
Thanks for your help





- Show quoted text -