=COUNTIF($A$2:$A$100,"*"&E2&"*")

where E2 houses a condition/criterion like earthlink.

Liz G Wrote:
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


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=274291