trouble with COUNTIF

[sophie619]

I'm probably forgetting something simple, but can someone take a look and tell me what's wrong? My COUNTIF statement doesn't seem to be working.

I've used Chip Pearson's "View Cell Contents" Add-in to see if the cells held any special characters, but from what I can tell, they match. But COUNTIF shows 0 in the range.
My Range is in Column A, the test criteria are in Column C, and I used FORMULATEXT in Column E to show the formulas used in Column D

Thanks in advance!

 

[GraH]

You are looking for literals, but the values in C are seen as "Less Then 3". Where you look for literally "<3".

Maybe try this.

Copy of Copy of PER SHEET.xlsx
	B	C	D	E	F
3	<3		<3		3
4	<6		<6		2
5	<9		<9		4
6	<9		12+		2
7	<9
8	12+
9	<3
10	<3
11	<6
12	<9
13	12+
Sheet1

Cell Formulas
Range	Formula
F3:F6	F3	=COUNTIF($B$3:$B$13,"*"&D3)

 

[sophie619]

Wow, I wouldn't have thought of that. Thank you! Worked perfectly.