Completed
) Example 5. Goal: Add Total Sales for each Product in the Year 2017. SUMIFS Example with Relative and Absolute Cell References.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Basics - SUMIFS, COUNTIFS, AVERAGEIFS Functions Calculations With One or More Criteria
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Review of SUMIFS and COUNTIFS examples we hjave already done in this class.
- 3 ) What is an AND Logical Test
- 4 ) Example 1. Goal: Count How Many BUSN Classes You Had With a Grade of 3 or Higher. COUNTIFS Example.
- 5 ) Excel and Access are NOT Case Sensitive
- 6 ) Example 2. Goal: Add Total Credits for BUSN Classes in the Year 2017. SUMIFS Example.
- 7 ) Example 3. Goal: Average Grades for BUSN Classes in the Year 2017. AVERAGEIFS Example.
- 8 ) Example 4. Goal: Add Total COGS for Quad Product in the Year 2017. SUMIFS Example.
- 9 ) Example 5. Goal: Add Total Sales for each Product in the Year 2017. SUMIFS Example with Relative and Absolute Cell References.
- 10 ) Example 6. Goal: Count number of Sales Great Than 2000 for each product in the year 2017. COUNTIFS function with 3 Criteria.
- 11 ) Example 7. Goal: Add Sales for each Product automatically with the SUMIFS function and the Excel Table feature.
- 12 ) Example 8. Goal: Count how many times an Assembly Line Post fell below the required Less Than 10 second assembly time. COUNTIFS Function.
- 13 ) 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 ) Summary - Conclusion
