Searching a text string in a range of cells.

How do i search for something within a text string in a cell which is in a
range of cells.

so if a cell contains the names "jim, bob, tom" what formula can i use to
just search for "bob"
I am currently using a SUMIF function which is only picking up cells that
only contain "bob" on its own.

=SUMIF(A1:A8,"*bob*",C1:C8)

will sum values in C1:C8 where A1:A8 contain "bob"

=COUNTIF(A1:A8,"*bob*")

will count occurences of "bob" in A1:A8 BUT only one occurence per cell i.e.
"bob,tom,jim,bob" in a cell will count as 1

HTH

"heenanmc" wrote:

> How do i search for something within a text string in a cell which is in a
> range of cells.
>
> so if a cell contains the names "jim, bob, tom" what formula can i use to
> just search for "bob"
> I am currently using a SUMIF function which is only picking up cells that
> only contain "bob" on its own.

Thank you very much! That worked perfectly!

"Toppers" wrote:

> =SUMIF(A1:A8,"*bob*",C1:C8)
>
> will sum values in C1:C8 where A1:A8 contain "bob"
>
> =COUNTIF(A1:A8,"*bob*")
>
> will count occurences of "bob" in A1:A8 BUT only one occurence per cell i.e.
> "bob,tom,jim,bob" in a cell will count as 1
>
> HTH
>
> "heenanmc" wrote:
>
> > How do i search for something within a text string in a cell which is in a
> > range of cells.
> >
> > so if a cell contains the names "jim, bob, tom" what formula can i use to
> > just search for "bob"
> > I am currently using a SUMIF function which is only picking up cells that
> > only contain "bob" on its own.