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

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

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

You can use wildcard characters with COUNTIF, like this:

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

Hope this helps.

Pete

On Feb 12, 10:56*am, Curly Worly <Curly
wrote:
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

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

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

"Pete_UK" wrote:

You can use wildcard characters with COUNTIF, like this:

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

Hope this helps.

Pete

On Feb 12, 10:56 am, Curly Worly <Curly
wrote:
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

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

You're welcome - thanks for feeding back.

Pete

On Feb 12, 12:28*pm, Curly Worly
wrote:
Thanks it worked. *I thought it would be something alot more complicated.. *
Thanks for your help



"Pete_UK" wrote:
You can use wildcard characters with COUNTIF, like this:

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

Hope this helps.

Pete

On Feb 12, 10:56 am, Curly Worly <Curly
wrote:
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- Hide quoted text -

- Show quoted text -