| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using COUNTIF for a word that is joined by another word in same ce
To make it easy, I am trying to count the number of times the name "Bob"
appears in a range of cells. Most of the time, "Bob" is the only name in the cell, so COUNTIF would work. However, sometimes there will be 2 names in the same cell, like this: "Joe/Bob." What kind of formula can I use to count the number of times "Bob" appears in a range of cells, including the times there are 2 names in the same cell? With the COUNTIF function, it is only counting the number of times "Bob" appears alone in a cell within the range of cells. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CountIf first column range = "Word" and second column range <> 0 | Excel Worksheet Functions | |||
| Can Excel Export Data to Word Format? | Excel Discussion (Misc queries) | |||
| How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
| Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) | |||
| COUNTIF text where there is more than one word in a cell | Excel Worksheet Functions | |||
Threaded Mode
