There are certainly multiple ways to do this, but here is one that I
think is pretty easy to understand for an Excel beginner:

Put this in E1:
=AND(A1="cvg",B1="i",C1="p",D1="ch") This will put the word true in
the cell if all criteria are met, and the word false if they are not
all met.
Copy the formula to all the rows.

And then count the number of times the formulas returned "True" in
another cell; something like this:

=COUNTIF(E1:E200,"true")


--
Lilliabeth
------------------------------------------------------------------------
Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741
View this thread: http://www.excelforum.com/showthread...hreadid=476354