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.