COUNTIFS in Excel 2016 (Multiple Criteria, Date, Wild Card etc)

COUNTIFS in Excel 2016: Learn more about how to use multiple criteria for counting function.
Complete Excel Foundation Course: https://shop.presentation-process.com...
What is covered in this Excel tutorial:
==============
00:00 What is Countif Function
01:18 Criterion for the formula
02:38 Set up multiple criteria in cells for counting
05:22 Set up Comparison with Operators (less than, more than etc.)
07:28 How to set up date criteria for Countifs
08:33 Using wild card operators for Countifs
09:37 Update Count automatically when you add entries
Useful best practice to save time for results to be updated automatically when you add data.

Download Exercise File to follow along easily:
https://drive.google.com/file/d/1XGDd...

Note: Countifs function is available from Excel 2007 onwards.

#ramgopalexcel
This video is created by Ramgopal from Presentation Process in Excel 2016 for Office 365. Visit Presentation-Process.com for more.