Excel - The COUNTIF and COUNTIFS Functions скачать в хорошем качестве

Excel - The COUNTIF and COUNTIFS Functions

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:    / @wiseowltutorials   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/video... 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!