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

  • Thread starter Thread starter Curly Worly
  • Start date Start date
C

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
 
You can use wildcard characters with COUNTIF, like this:

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

Hope this helps.

Pete
 
Thanks it worked. I thought it would be something alot more complicated.
Thanks for your help
 
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 -
Click to expand...
 
Back
Top