By Andrew Gould

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

Download files here https://www.wiseowl.co.uk/excel/videos/excel-general/excel-countif-countifs/

Learn how to count values based on conditions using the COUNTIF and COUNTIFS functions in Microsoft Excel.

Chapters
00:00 Topic list
00:59 A Basic COUNTIF Example
02:57 Using Named Ranges
04:42 Logical Tests in COUNTIF
06:06 The COUNTIFS Function
07:44 Counting Values Between
08:43 Concatenating Criteria
10:27 Criteria with Dates
12:06 Dynamic Date Criteria
13:39 Basic Text Criteria
14:43 Using Wildcard Characters
16:12 Validating Results using the Autofilter
17:47 Multiple Text Criteria
19:32 The Question Mark Wildcard
20:49 Combining Wildcards
22:14 Counting Wildcards
24:40 Summarising a List
27:12 Creating a Matrix of Counts

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!