Hello,

I'm trying to come up with a formula to count that number of item's that match mulitple criteria. In order to find a match I need to look inside a cell's text and look for specific letters or numbers.

In Column A I have a bunch of numbers and in column B are a bunch of sentences. There are 10,000 or so row's of data for each column. I need a formula that will first look for a matching number from Column A and then will allow me to enter anywhere from 2 to 5 wildcard phrases to search for in column B. The formula should then count all of the matches

So for example I might want to look for the number 5405 in column A and then for the phrases "E54", "NB3", and "Heritage" in column B and give me a total count for all matches.

Any help would be greatly appreciated