=COUNT(IF(('NON-APPLICABLE'!I3:I2113="MI")*(ISNUMBER(FIND("No draw or
progressive, plastic injection
molds",'NON-APPLICABLE'!P3:P2113))),'NON-APPLICABLE'!E3:E2113))

still an array formula

--

HTH

RP
(remove nothere from the email address if mailing direct)


"hopeit" wrote in message
...
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.