=COUNTIF(A1:A100,"*aol*")

and then add another for earthlink, etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Liz G" wrote in message
...
Hi,

I have a comment field where users were asked to list their past ISP's. I
need a quick and easy way to count cells according to the ISP's they
listed.
For instance, one person may have listed aol, earthlink, and netzero all
in
one cell. I need a way to count the number of people that listed aol, the
number of people that listed earthlink, and the number of people that
listed
netzero separately. The 'countif()' function only counts a cell if that
person just listed aol or just listed earthlink but not if both are in one
cell. Please help! (Otherwise I have to go through 3500 comment fields
and
manual count each ISP each person listed). Thank you!

Liz