Hi,

I have been trying to figure this out with no luck. I am trying to
count the number of occurences that "textvalue1" appears on the same
row with "textvalue2". Both "textvalue1" and "textvalue2" appear in
random areas of a cell range (c2:n999). Essentially I would like to do
something like this:

=COUNTIF(c2:n999,"textvalue1")AND IF
=COUNTIF(c2:n999,"textvalue2")

and then display the number of occurences that both textvalue1 and
textvalue2 appear in the same row together? Is this possible with a
cell range like this or should I just stop.

Thanks.


--
5dolla
------------------------------------------------------------------------
5dolla's Profile: http://www.excelforum.com/member.php...o&userid=36493
View this thread: http://www.excelforum.com/showthread...hreadid=562529