Sumproduct

[gymwrecker]

Need help with the below formula. I need to SUMPRODUCT three conditions; the formula below is returning me a "0" when in fact I counted "13" items that meet the 0084, OD, and 1A. criteria. What could be wrong or missing?


=SUMPRODUCT(ISNUMBER(SEARCH("*0084*",Master!$A$2:$A$1000)*ISNUMBER(SEARCH("*OD*",Master!$K2:$K1000)*ISNUMBER(SEARCH("*1A.*",Master!$U$2:$U1000))))

 

[MrKowz]

You weren't closing your ISNUMBER statements:

=SUMPRODUCT(ISNUMBER(SEARCH("*0084*",Master!$A$2:$A$1000))*ISNUMBER(SEARCH("*OD*",Master!$K2:$K1000))*ISNUMBER(SEARCH("*1A.*",Master!$U$2:$U1000)))

 

[gymwrecker]

Thanks MrKowz! Formula is working perfectly now.

=SUMPRODUCT(ISNUMBER(SEARCH("*0084*",Master!$A$2:$A$1000))*ISNUMBER(SEARCH("*OD*",Master!$K2:$K1000))*ISNUMBER(SEARCH("*1A.*",Master!$U$2:$U$1000)))

I have one more question, on the third array, I have cells that are "blank", how can I fix the formula so it can identify the "blank" cells?