You mixed you delimiters for the function... your first two delimiters are commas but your last three are semi-colons. Assuming commas throughout, your formula would be...Hi Vshurden,
the formula for H3 (assuming you have your check formula there) would be:
=COUNTIFS(A$3:A$150,E3,B$3:B$150;F3;C$3:C$150;G3)
If that formula shows a 1, there is a match somewhere, if it's >1 there are multiple matches, if it's a 0, you have no matches.