SUMPRODUCT issues

[ryokahn]

Hello all,



I’ve been using this formula for a while now, but I waswondering if I can get the formula to find WASH instead of the information on Sheet1!$A4.There are several different narratives for wash but WASH is always in thenarrative. Please help! Thank you foryour time!





=SUMPRODUCT(('INSPECTIONLISTING'!$A$2:$A$50000=Sheet1!D$3)*('INSPECTIONLISTING'!$H$2:$H$50000=Sheet1!$A4))

 

[Eric W]

Try:

=SUMPRODUCT((inspectionlisting!$A$2:$A$50000=Sheet1!D$3)*ISNUMBER(SEARCH("WASH",inspectionlisting!$H$2:$H$50000)))

 

[ryokahn]

Try:

=SUMPRODUCT((inspectionlisting!$A$2:$A$50000=Sheet1!D$3)*ISNUMBER(SEARCH("WASH",inspectionlisting!$H$2:$H$50000)))

You are a life saver!!! I can't thank you enough!!!!

 

[Eric W]

You're welcome!