parentheses are missing
use
=(COUNTIF(X7:X65536,"NO MATCH"))-(SUMPRODUCT((A7:A65536>0)*(R7:R65536="")))
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks