variation on countif?

[Liz G]

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]

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

where E2 houses a condition/criterion like earthlink.

 

[Bob Phillips]

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

and then add another for earthlink, etc.

--

HTH

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