variation on countif?
 

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

=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

=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