Countif with multiple variable criteria and wildcard "*"

Hello all,

I have a table with multiple columns. One of the columns is named EQUIP and has the names of different equipment. Some of these machines have chambers where the products run. When the product runs in a machine with a chamber, it gets a suffix with the name of the chamber - for example, The machine is named HDP06 and it has a chamber so if the product runs in HDP06 - it will show as HDP06-A

I want to create a pivot table based on all the machines over a period which the user chooses.

The user can choose to exclude certain machines from the table with a wildcard. The users machines will be placed in a different column.

If the user enters HDP06, I want to filter all tools that contain HDP06, this could mean HDP06-A/B/C

I tried using the following but got an error.

=countif(I$2:I$10&"*", [@equip])

I$2:I$10 contains the excluded list.

If the machine exists in the excluded list, the countif should return 1.

I know that the problem is because of the use of the wildcard on the range but I can't think of anything else.

Any help is appreciated.

=SUMPRODUCT(--ISNUMBER(SEARCH([@equip],I$2:I$10)))

tim201110, thanks for taking the time to help.

I get a 1 for the first row in the table but after that all others are 0.

In the criteria range, there are more than 1 machine to filter out so it should be showing more than one "1".