Search Criteria / Formula

Need help with the below formula! I need the third search criteria ")))*ISNUMBER(SEARCH("*1*",INDIRECT("FSR!$K$2:$K$1 500")))) to count and return any number greater than 50. How can I adjust this formula to do that? Basically is going to look for "88DAA", "MG", and return the number of fields (count), over 50 between $K$2:$K$1500, that meet the three criterias. Please advise.

=SUMPRODUCT(ISNUMBER(SEARCH("*88DAA*",INDIRECT("FS R!$B$2:$B$1500")))*ISNUMBER(SEARCH("*MG*",INDIRECT ("FSR!$G$2:$G$1500")))*ISNUMBER(SEARCH("*1*",INDIR ECT("FSR!$K$2:$K$1500"))))

Thank you!

I don't think you need INDIRECT. Anyway, try this one

=SUMPRODUCT(--(ISNUMBER(SEARCH("*88DAA*",FSR!$B$2:$B$1500))),--ISNUMBER(SEARCH("*MG*",FSR!$G$2:$G$1500)),--(FSR!$K$2:$K$1500>50))

Quote:

---

Originally Posted by Admin

I don't think you need INDIRECT. Anyway, try this one

=SUMPRODUCT(--(ISNUMBER(SEARCH("*88DAA*",FSR!$B$2:$B$1500))),--ISNUMBER(SEARCH("*MG*",FSR!$G$2:$G$1500)),--(FSR!$K$2:$K$1500>50))

---

I do not think you need those asterisks inside the SEARCH function calls.