I have the following formula - and will break it down where mistake is occurring.

="x "&COUNTIF($A$2:$E$71,G$80)-(ISNUMBER(MATCH(G$80,$E$79:$I$79,0)+ISNUMBER(MATCH(G$80,MMQPs!D$2:H$2,0))))

="x "&COUNTIF($A$2:$E$71,G$80) ----- Currently this portion works correctly and displays a value of 2

="x "&COUNTIF($A$2:$E$71,G$80)-(ISNUMBER(MATCH(G$80,$E$79:$I$79,0) this portion works correctly. Currently it shows 1 because it minus 1 from from match (e79-I79)

The last portion is not coming up with a value - EVEN THOUGH there is a match! Gives a value of 0 (MMQPs!D$2:H$2)

+ISNUMBER(MATCH(G$80,MMQPs!D$2:H$2,0))))

Basically I need to add total matches from both matches and be subtracted from the countif.

Correct count should be 0 as there is a match from first match and a match from second match. They are not adding!

Thanks Jack