To count the number of occurrences for a range or multiple items use the COUNTIFS function. When it comes to a date range, whether is it for a month, quarter, or any date range, the COUNTIFS function is what you need. Examples: How many orders did we get for Quarter 1? That is the COUNTIFS function since it is between a range of dates. How many times was product A ordered for customers in Australia? How many orders did we have between January 1 and March 31? The COUNTIF function, which I covered in this video, will handle one criterion. COUNTIFS handle multiple criteria. TimeStamps: 01:07 Countif function 02:30 Countifs with text. 03:50 FormulaText function 04:37 Countifs with dates method 1 07:40 Countifs with dates method 2 10:20 Countifs with dates method 3 using EOMONTH function In this video, I'll show three methods for doing Countifs between dates. Method 1 is typing the date in the function Method 2 is typing a Start and End date and using concatenate in Excel to join COUNTIFS with the cell reference. Method 3 is using the EOMONTH function in Excel. #msexcel #excel #exceltraining #countifsexcel #excelcountifs Chris Menard's website: Upcoming live event: Chris Menard will speak to the DeKalb Chapter of CPAs, part of the Georgia Society of CPAs on February 25, 2020. Menard's presentation will be Excel Analysis and PivotTables. And make sure you subscribe to my channel! -- EQUIPMENT USED --------------------------------- ○ My camera – ○ Microphone - ○ Camera tripod – ○ Studio lights - ○ Dual monitor mount stand - ○ Web camera – ○ Shock mount - ○ Boom Arm - -- SOFTWARE USED --------------------------------- ○ Screen recording – Camtasia – ○ Screenshots – Snagit – ○ YouTube keyword search – TubeBuddy – 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!