OOPS, I spoke too soon. It's still not counting every instance of what I need
to count.

Hopeit

"Biff" wrote:

Hi!

Try this:

Normally entered

=SUMPRODUCT(--('NON-APPLICABLE'!I3:I2113="MI"),--(ISNUMBER(SEARCH("No draw
or progressive, plastic injection
molds",'NON-APPLICABLE'!AP3:AP2113))),--(ISNUMBER('NON-APPLICABLE'!E3:E2113)))

Biff

"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.