Excel COUNTIF Function With Wildcard Search and Cell Reference

The COUNTIF function in Excel allows you to only count the number of cells that meet certain criteria. For example, the number of cells that the HR department appears in. With COUNTIF, you can do a wildcard search by using * (asterisk). The asterisk looks for any number of characters. For example, *east finds "Northeast" and "Southeast". With COUNTIF you can reference a cell also. The issue comes up with using a wildcard search with a cell reference. To accomplish this, we will use CONCATENATE or & with the cell reference. Chapters: 0:00 Intro 0:15 COUNTIF explained 1:05 COUNTIF with wildcard 1:56 COUNTIF with cell reference wildcard COUNTIF Function has two required arguments. The criteria is not case-sensitive. All caps or lowercase or mixed - it doesn't matter. =countif(b2:b25,"HR") will count HR in cells B2 through B25. If cell B4 reads "HR Department" without the quotes, it could not be counted. =countif(b2:b25,"*atl*") will count ATL in cells B2 through B25. If cell B4 read "Lives in ATL" without the quotes, it would be counted since we have wildcard before and after atl. Related videos Averageif with wildcard by Menard https://www.youtube.com/watch?v=4xZ0lDlKN4o MedianIF two methods https://www.youtube.com/watch?v=F6UgujanjAs Chris Menard's Blog Post https://chrismenardtraining.com/post/excel-countif-function-wildcard-search-and-cell-reference NOTE: To count multiple criteria, use the COUNTIFS functions. #chrismenardtraining #UGA #exceltraining #microsoftexcel #excelfunction And make sure you subscribe to my channel! -- EQUIPMENT USED --------------------------------- ○ My camera – https://amzn.to/3vdgF5E ○ Microphone - https://amzn.to/3gphDXh ○ Camera tripod – https://amzn.to/3veN6Rg ○ Studio lights - https://amzn.to/3vaxyy5 ○ Dual monitor mount stand - https://amzn.to/3vbZSjJ ○ Web camera – https://amzn.to/2Tg75Sn ○ Shock mount - https://amzn.to/3g96FGj ○ Boom Arm - https://amzn.to/3g8cNi6 -- SOFTWARE USED --------------------------------- ○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia ○ Screenshots – Snagit – https://chrismenardtraining.com/snagit ○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!