Trouble with wildcard

[4lowie]

Hi all
I'm having trouble using wild cards....

I have a countif formula that works with a single selection, I want it to select on string out of a cell containing text.
In the case I want to count CNF. I've tried * and ~ but can't get it to work.....

Cell text in question.
REL CNF PRT MACM PRC SETC SKKP

=COUNTIFS(E3:E352,"<="&B1,E3:E352,">="&B2,E3:E352,"CNF")

Any idea's??

Thanksks Dave

 

[helpexce]

Try this.
=COUNTIF(A1,"*CNF*")

This one for counting only with data containing "CNF". You can make as u need.