LinkBack URL
About LinkBacks
Or you may use IFERROR to exclude errors like this.....
Don't forget to confirm it with Ctrl+Shift+Enter instead of just Enter as this is an Array Formula.
=SUMPRODUCT(IFERROR(1/COUNTIF(G2:G2000,G2:G2000)*(J2:J2000=N2),0))
Does this help?
Or you may use IFERROR to exclude errors like this.....
Don't forget to confirm it with Ctrl+Shift+Enter instead of just Enter as this is an Array Formula.=SUMPRODUCT(IFERROR(1/COUNTIF(G2:G2000,G2:G2000)*(J2:J2000=N2),0))
Does this help?
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks