Excel Basics 19: SUMIFS, COUNTIFS, AVERAGEIFS, functions calculations w 1 or more Criteria

Excel 2016 Basics Free Course - Learn to Efficiently Use Excel at Work and to Get a Job. - Excel Basics 19: SUMIFS, COUNTIFS, AVERAGEIFS, functions calculations w 1 or more Criteria

4.0 (3)

24 learners

What you'll learn

This course includes

12.3 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

Highline College Busn 216 Mike Girvin Michael Girvin excelisfun Excel Basics Learn Excel Excel Excel 2016 Learn Excel Online Complete Lesson in Excel Basic Excel

Full Transcript

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin. Download Excel Start & Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EB19-SUMIFSandSimilarFunctions.xlsm Download Full Written Notes: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Office2016Class31-ExcelBasics19-SUMIFSandSimilarFunctions.pdf Class web page link: https://people.highline.edu/mgirvin/AllClasses/216v2016/Content/04Excel/Excel2016.htm Topics in this video: 1. (00:01) Introduction 2. (01:30) Review of SUMIFS and COUNTIFS examples we hjave already done in this class. 3. (03:38) What is an AND Logical Test 4. (06:40) Example 1. Goal: Count How Many BUSN Classes You Had With a Grade of 3 or Higher. COUNTIFS Example. 5. (10:52) Excel and Access are NOT Case Sensitive 6. (11:59) Example 2. Goal: Add Total Credits for BUSN Classes in the Year 2017. SUMIFS Example. 7. (14:14) Example 3. Goal: Average Grades for BUSN Classes in the Year 2017. AVERAGEIFS Example. 8. (16:11) Example 4. Goal: Add Total COGS for Quad Product in the Year 2017. SUMIFS Example. 9. (18:03) Example 5. Goal: Add Total Sales for each Product in the Year 2017. SUMIFS Example with Relative and Absolute Cell References. 10. (20:39) Example 6. Goal: Count number of Sales Great Than 2000 for each product in the year 2017. COUNTIFS function with 3 Criteria. 11. (24:22) Example 7. Goal: Add Sales for each Product automatically with the SUMIFS function and the Excel Table feature. 12. (27:21) Example 8. Goal: Count how many times an Assembly Line Post fell below the required Less Than 10 second assembly time. COUNTIFS Function. 13. (29:37) Example 9-10. Goal: Find Min Time for Each Assembly Line Post. See the New MAXIFS and MINIFS Functions in Office 365 Excel 2016. 14. (33:34) Summary - Conclusion Adding with Conditions Criteria, Counting with Conditions Criteria, Average with Conditions Criteria,