Countif function help

[Coachclw87]

I am trying to use the count if function and I am running into a bit of an issue. Just for example I want to count the number of cells that contain the text "1h", so I type the formula =countif(P9:P13,"*1h*")
The answer I am looking for should be 1, but it's coming back as 2. It's counting one of the cells that contains "21h" in the cell. Any suggestions?

 

[AhoyNC]

See if this works.
I used cell Q7 to add the extra search (change to range you want to use).
If cell Q7 is left blank it would return 2 in the example below.

Excel Workbook
	P	Q
6		Find with Code Chart D5
7		D
8		1
9	34R+ 30H+
10	34R-
11	21D+ 1H#
12	34R- 21H+
13	1H
Sheet