Morning
I have a COUNTIF formula which counts the amount of "NO MATCH"es I get in column X
The result in my current case has 71 "NO MATCH"es.Please Login or Register to view this content.
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
The result in this case is 2.Please Login or Register to view this content.
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
But all I'm getting is #VALUE!Please Login or Register to view this content.
Can anyone tell me what is wrong with my formula here?
Thanks in advance.
Bookmarks