The COUNTIF function is a function in Excel that filters out data to a specific criteria and then counts the total number of cells that contain data that match the criteria. In this short Microsoft Excel tutorial I am showing you examples of how and when you would use the COUNTIF function and COUNTIFS function in Microsoft Excel. I also show you how to use wild card characters with the COUNTIF funtion. I also briefly show you why you may want to use the COUNTIF function instead of using an Excel Table which can also perform the same function.
0:00 COUNTIF Intro
2:12 How to Use the COUNTIF Function
5:33 COUNTIF Function Greater Than or Less Than Values
7:02 COUTIF Function using Wild Card Characters
13:28 COUTIFS Function in Excel
16:27 COUNTIF vs Using Excel Tables