| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a formula to count only unique items in a column? | Excel Worksheet Functions | |||
| SUMPRODUCT to count items with duplicates where another column contains two defined items | Excel Worksheet Functions | |||
| Formula to count month-specific items | Excel Discussion (Misc queries) | |||
| How do I set up a formula to count only unique items in a column? | Excel Worksheet Functions | |||
| How do I set up a formula to count multiple items? | Excel Worksheet Functions | |||
Hybrid Mode
