Excel 2007 : Subtracting a SUMPRODUCT result from a COUNTIF result

Morning

I have a COUNTIF formula which counts the amount of "NO MATCH"es I get in column X

Please Login or Register  to view this content.

The result in my current case has 71 "NO MATCH"es.

I then have a SUMPRODUCT which counts the amount of blanks there are in column R as long as column A has data in it

Please Login or Register  to view this content.

The result in this case is 2.

I then use a seperate field to minus the SUMPRODUCT from the COUNTIF. The result is 69. Which is what I'm after.

That's fine and all, but to use 3 fields to do the job of 1 is ludicrous.

I have tried to combine them into one formula with the below

Please Login or Register  to view this content.

But all I'm getting is #VALUE!
Can anyone tell me what is wrong with my formula here?

Thanks in advance.

parentheses are missing

use

=(COUNTIF(X7:X65536,"NO MATCH"))-(SUMPRODUCT((A7:A65536>0)*(R7:R65536="")))