COUNTIF Function in Excel Tutorial - (Realistic Examples) COUNTIFS & Wild Card Characters

COUNTIF Function in Excel Tutorial - (Realistic Examples) COUNTIFS & Wild Card Characters

558 Lượt nghe
COUNTIF Function in Excel Tutorial - (Realistic Examples) COUNTIFS & Wild Card Characters
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