Wildcard variables with countif statement

  • Thread starter Thread starter Fopma
  • Start date Start date
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wildcard characters in countif array formulas 4
Wildcards '*/' in Count IF Statements 1
COUNTIF with wildcards 3
wildcard in countif formula that uses cell references 3
COUNTIFS - 2 different scenarios to count 2
Wildcards in Array Formulas 1
ARRAY with countif 6
search for text "beginning with" "containing" wildcards 1

Back
Top