In this video, I will show you how to use the COUNTIF and COUNTIFS functions to create formulas in Microsoft Excel. I will demonstrate how to use the COUNTIF with one criterion or COUNTIFS with multiple criteria. Also included in this Excel functions tutorial is how to use wildcards in your formulas.

Practice sheet: https://leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/ERb6QtZDTfpLn11fzdmex6cBORS5L2IyljE9CviTaA259Q?e=rdkeUv

More Excel Function Tutorials: https://youtube.com/playlist?list=PLmkaw6oRnRv_GeQNcc_hHtnxbRC7gDLST

I'm using Office 365 in my demo.

0:00 Introduction
1:14 COUNTIF Formula with numbers
3:04 COUNTIF with numbers greater than
4:45 COUNTIF with letters or words
5:30 COUNTIF with operations
7:25 COUNTIF with wildcards (asterisk and question mark)
11:00 COUNTIFS multiple criteria