LinkBack URL
About LinkBacks
Nevermind, I found my solution
Just needed ISNUMBER() modifier...and the -- coersion
=SUMPRODUCT(--ISNUMBER(SEARCH(B19&"-"&C19,Sheet1!A:A)),Sheet1!B:B,--ISNUMBER(SEARCH("SP",Sheet1!A:A)))
Nevermind, I found my solution
Just needed ISNUMBER() modifier...and the -- coersion=SUMPRODUCT(--ISNUMBER(SEARCH(B19&"-"&C19,Sheet1!A:A)),Sheet1!B:B,--ISNUMBER(SEARCH("SP",Sheet1!A:A)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks