Very nice Dave.........I love that one but can never remember it
<g...........by the way, did you see that it only counts bob/bob/bob as
just one "bob"? .......of course I doubt the OP will experience that
combination, but just a curiosity.....it's apparently counting cells that it
finds a bob in rather than the bob's themselves...........

Vaya con Dios,
Chuck, CABGx3




"Dave Peterson" wrote in message
...
maybe

=countif(a1:a10,"*bob*")

But if Bob is embedded in another name, it'll get counted.

Jim/Nabob/ralph

(I couldn't think of another name!)

James wrote:

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.

--

Dave Peterson