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.=COUNTIF(X7:X65536,"NO MATCH")
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.=SUMPRODUCT((D7:D65536>0)*(R7:R65536=""))
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!=(COUNTIF(X7:X65536,"NO MATCH")-(SUMPRODUCT((A7:A65536>0)*R7:R65536="")))
Can anyone tell me what is wrong with my formula here?
Thanks in advance.
Last edited by Nikeyg; 10-20-2011 at 05:44 AM.
parentheses are missing
use
=(COUNTIF(X7:X65536,"NO MATCH"))-(SUMPRODUCT((A7:A65536>0)*(R7:R65536="")))
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Thanks Azam!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks