how to have multiple ISNUMBER search function in SUMPRODUCT

[melvyndb]

Hi all,

Any ideas on thread title?

I tried doing it, but the results is wrong.

=SUMPRODUCT((ISNUMBER(SEARCH({"2012-0","2012-1.1","2012-1.2","Q42011"},D!L2:L25550)))*(D!W2:W25550="Open")*(ISNUMBER(SEARCH({"CA","CAB","CAC","CAD"},D!Z2:Z25550)))*(D!M2:M25550="A")*(D!AD2:AD25550="reviewed")*(D!AF2:AF25550="yes"))

If i had only 1 ISNUMBER SEARCH function, it works.