COUNTIFS having a range as criteria

Hi,
I have a situation where in I have to use COUNTIFS(range1, Criteria1, Range2, Criteria2...), where criteria should be a range in the same excel that has text in it. Is there a way for that? My actual situation is
Sheet 1 : col A and Col B - Text values
Sheet 2 : Col C and Col D - Text values

For every value in Col A, check if it is there in Col C, the take the corresponding value from Col D and check if it is the same in Col B. I need the count of how many matches or doesn't match. I tried to use Vlookup on this, but couldn't get what I wanted. I appreciate your suggestions on this.

If I can know if a "Range of text" can be used in the CRITERIA part, it would be great.
table2.JPG

This is absolutely what I needed :-) Thank you very much :-)