Formula is not giving correct answer

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

I believe I figured it out...At least its giving correct total now......

This is what I had before:

="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))))

This seems to be working:

="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)))


Thanks for your quick reply.......Keep up the great work!
Jack