Completed
1. Introduction
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Formulas for Counting and Adding: COUNT, COUNTA, ROWS, SUM, SUMIFS, COUNTIFS and IF Functions - Part 2
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Introduction
- 2 2. Topics in Video
- 3 3. Count or add all Numbers, Text Items or Records using the functions: COUNT, COUNTA, ROWS and SUM.
- 4 4. Count or add with a single condition using COUNTIFS and SUMIFS functions
- 5 5. UNIQUE, SORT & SUMIFS to create a Sales Report for Sales Reps. Learn about the # Spilled Range Operator and how array formulas in MS 365 are dynamic.
- 6 6. Excel’s Golden Rule for adding and counting with criteria. Learn why the origimal spreadsheet was invented.
- 7 7. Using keyboards to enter ranges into function
- 8 8. Excel Text Formulas using the Ampersand &. What is a #NAME? error?
- 9 9. Accounting or Currency Number Formatting? What is difference?
- 10 10. AND Logical Test or OR Logical Test for adding or counting with Two or More Conditions
- 11 11. Simple business example to illustrate an AND Logical Test.
- 12 12. SUMIFS and COUNTIFS to add or count when you have two conditions running in an AND Logical Test
- 13 13. Using Comparative Operators with conditions to add or count
- 14 14. OR Logical Test run across a single column using the functions SUM, COUNTIFS and SUMIFS using a function argument array operation
- 15 15. OR Logical Test run across a two columns using a custom built Array Logical Test with the SUM and IF functions
- 16 16. SEQUENCE & COUNTIFS functions to build Assembly Lime Time Report.
- 17 17. MAXIFS and MINFS functions to build ab Assembly Line Max and MIN Time Report
- 18 18. Summary
- 19 19. Practice Problems for you!
- 20 20. Closing and video link
