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
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
Code:
Code:
Any idea's??
Thanksks Dave