Completed
6. Excel’s Golden Rule for adding and counting with criteria. Learn why the origimal spreadsheet was invented.
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
