I have a spread sheet that has several columns. I have created a nested array
formula to tell me how many items fall into my criteria, but I am missing
some information, see fomula below:


{=COUNT(IF(('NON-APPLICABLE'!I3:I2113="MI")*('NON-APPLICABLE'!AP3:AP2113="No
draw or progressive, plastic injection molds"),'NON-APPLICABLE'!E3:E2113))}

My problem is that I may or may not add information into the column
containing the statement "No draw or progressive..." I need to know how to
get a wild card to work after the word "molds". With the statement above, it
counts just that and nothing else. I can get the wild card to work in any
other formula.