LinkBack URL
About LinkBacks
Hi there, welcome to the Forum!
Try using ISNUMBER(FIND()) like this
=SUMPRODUCT(--(Data!A2:A3000="person")*--(ISNUMBER(FIND("ABC",Data!G2:G3000))))
Hi there, welcome to the Forum!
Try using ISNUMBER(FIND()) like this
=SUMPRODUCT(--(Data!A2:A3000="person")*--(ISNUMBER(FIND("ABC",Data!G2:G3000))))
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
This formula will work but, really, you are mixing up syntaxes unnecessarily here, if you use * you don't need -- and vice versa, so probably you would normally use either this versionOriginally Posted by DGagnon
=SUMPRODUCT((Data!A2:A3000="person")*ISNUMBER(FIND("ABC",Data!G2:G3000)))
....where multiplying the two arrays using * implicitly co-erces the TRUEs to 1s and the FALSEs to zeroes, or this one.....
=SUMPRODUCT(--(Data!A2:A3000="person"),--ISNUMBER(FIND("ABC",Data!G2:G3000)))
where -- explicitly co-erces each array
Last edited by daddylonglegs; 04-09-2012 at 10:24 AM.
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks