CountIf and VLookup - 2 sheets, 4 columns

[ld1551]

I need to count how many rows with specific criteria do not match the same criteria on another sheet.

Sheet 1 is on the left, sheet 2 is on the right.

Both sheets have 2 columns. I need to do a countif and vlook up combinaton of sorts. When the columns of both sheets are combined, I need to do a vlookup to see what from sheet 1 IS NOT FOUND in Sheet 2. In the attached screenshot here would be two instances of rows that did not match or were not found on sheet 2.

Can anyone assist?

Thank you.Capture.PNG

[benishiryo]

try this in Sheet1 cell C2:
=COUNTIFS(Sheet2!A:A,A2,Sheet2!B:B,B2)

[ld1551]

I'm looking to get the actual summed count of the non-matches.

[benishiryo]

maybe something along:
=SUMPRODUCT(COUNTIFS(Sheet2!A:A,A2:A10,Sheet2!B:B,"<>"&B2:B10))