Wildcard variables with countif statement

F

Fopma

Is there any way to count values for fields which
contain "/2" in the text? Ie: how do you incorporate the
wildcard feature to allow all values to be returned, eg.
123456/2; 245678/2 etc.

=COUNT(IF(F2="?/2",M2:M$3))

I have tried the ? and vilde wildcards but there do not
return a value.
 
Top