Mr Excel & excelisfun Trick #3: Wildcard Count

See Mr Excel and excelisfun demonstrate three methods to count words that contain the letter D:
1) Filter & SUBTOTAL
2) Table & SUBTOTAL
3) COUNTIF and criteria syntax

Count with criteria conditions. Use wildcards in criteria conditions.

MrExcel's Learn Excel #980 - Dueling: Wildcard Match

Category:

Science & Technology

Tags:

• Excel
• Filter
• Tables
• COUNTIF
• SUBTOTAL
• Count
• words
• that
• contain
• certain
• letters
• wildcards
• for
• criteria
• condition
• excelisfun
• Bill
• Mr
• Jelen
• Mike
• Gel
• Girvin
• Highline
• Community
• College
• Duel
• Dueling

[2107Gopal]

It was a great lesson for me, but i have a question.

What if a cell contains more than 1 similar character, because then its not working.

[ExcelIsFun]

Anytime you do a partial match like this, it is not possible to get it to work 100% of the time. Such is the nature of a partial match. I do not know how to solve this problem.

[xmcMaEc]

@ExcelIsFun why don't you use a text formula to breakdown the Service records by columns? 1 column per letter, example column1.type will be D, Column2.type will be M and column3.type will be P and at the end you culd use boolean logic or countif's to get that exact count?

[ExcelIsFun]

Which ever method works... COUNTIF with wild card seems an easy way.

[darrencornell1]

this is so cool

[ExcelIsFun]

I am glad that you like it!

[edcabading]

Hello Mr. Girvin and Mr. Excel,

I've tried using =DCOUNTA(data base, column number of field to count, criteria)

NOTE : that criteria 'CONTAINS" is FILED NAME ON TOP THE NEXT ROW =*M*, NEXT ROW =*D* THEN NEXT ROW =*P*

[ExcelIsFun]

That would be fun! Send a note to MrExcel and let him know! He is bjele123 at YouTube.

[TheMrBenjamin]

Hey,

You guys should do a tour in London. I attended an Excel course but my tutor ddnt know half the stuff you guys do let alone be able to teach it effectively.