Excel Formulas for Counting and Adding: COUNT, COUNTA, ROWS, SUM, SUMIFS, COUNTIFS and IF Functions - Part 2

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Learn essential Excel formula techniques for counting and adding in this comprehensive 52-minute video tutorial taught by experienced Highline College Professor Mike Girvin. Master 10 different Excel Built-in Functions including COUNT, COUNTA, ROWS, SUM, SUMIFS, COUNTIFS, and IF through practical business examples. Explore how to perform calculations with single and multiple conditions using AND/OR Logical Tests, work with array formulas in MS 365, understand the Spilled Range Operator, and create dynamic sales reports. Discover the differences between Accounting and Currency formatting, learn to handle text formulas with ampersands, troubleshoot #NAME errors, and build assembly line time reports using SEQUENCE, MAXIFS, and MINIFS functions. Practice newly acquired skills with provided exercise problems and access downloadable Excel files and PDF notes for hands-on learning.

Syllabus

1. Introduction
2. Topics in Video
3. Count or add all Numbers, Text Items or Records using the functions: COUNT, COUNTA, ROWS and SUM.
4. Count or add with a single condition using COUNTIFS and SUMIFS functions
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. Excel’s Golden Rule for adding and counting with criteria. Learn why the origimal spreadsheet was invented.
7. Using keyboards to enter ranges into function
8. Excel Text Formulas using the Ampersand &. What is a #NAME? error?
9. Accounting or Currency Number Formatting? What is difference?
10. AND Logical Test or OR Logical Test for adding or counting with Two or More Conditions
11. Simple business example to illustrate an AND Logical Test.
12. SUMIFS and COUNTIFS to add or count when you have two conditions running in an AND Logical Test
13. Using Comparative Operators with conditions to add or count
14. OR Logical Test run across a single column using the functions SUM, COUNTIFS and SUMIFS using a function argument array operation
15. OR Logical Test run across a two columns using a custom built Array Logical Test with the SUM and IF functions
16. SEQUENCE & COUNTIFS functions to build Assembly Lime Time Report.
17. MAXIFS and MINFS functions to build ab Assembly Line Max and MIN Time Report
18. Summary
19. Practice Problems for you!
20. Closing and video link