Channel: Teacher's Tech

Category: Education

Tags: countifs with multiple criteriacountif formula in exceljamie keetexcel countifsteacher's tech tutorialscountifs functioncountifs multiple criteriacountif function in excelwildcards in excelexcelhow to use countif in excelhow to use countif and countifs in excelcountifscountifcountif wildcards

Description: 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: leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/ERb6QtZDTfpLn11fzdmex6cBORS5L2IyljE9CviTaA259Q?e=rdkeUv More Excel Function Tutorials: 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