MS 365 Excel Basics #2: Add & Count Formulas with COUNT, COUNTA, ROWS, SUM, SUMIFS, COUNTIFS & IF

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/ExcelBasics02.xlsx
pdf notes: https://excelisfun.net/files/ExcelBasics02.pdf
In this video learn every trick there is for Excel formula counting and adding with 10 different Excel Built-in Functions, including how to add and count with a single condition, two or more conditions, an AND Logical Test, and even the elusive OR Logical Test. See many use business examples.
This video is taught by Mike “excelisfun” Girvin, Highline College Profession since 2002 years and excelisfun YouTuber since 2008. This video is #2 in a class of 10 free videos and Excel files! This is a free YouTube class that teaches you all about Microsoft 365 Excel.
Topics in Video:
1. (00:00) Introduction
2. (00:28) Topics in Video
3. (01:23) Count or add all Numbers, Text Items or Records using the functions: COUNT, COUNTA, ROWS and SUM.
4. (04:03) Count or add with a single condition using COUNTIFS and SUMIFS functions
5. (09:07) 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. (13:47) Excel’s Golden Rule for adding and counting with criteria. Learn why the origimal spreadsheet was invented.
7. (16:05) Using keyboards to enter ranges into function
8. (17:31) Excel Text Formulas using the Ampersand &. What is a #NAME? error?
9. (23:02) Accounting or Currency Number Formatting? What is difference?
10. (24:20) AND Logical Test or OR Logical Test for adding or counting with Two or More Conditions
11. (26:31) Simple business example to illustrate an AND Logical Test.
12. (27:39) SUMIFS and COUNTIFS to add or count when you have two conditions running in an AND Logical Test
13. (30:35) Using Comparative Operators with conditions to add or count
14. (33:40) OR Logical Test run across a single column using the functions SUM, COUNTIFS and SUMIFS using a function argument array operation
15. (38:15) OR Logical Test run across a two columns using a custom built Array Logical Test with the SUM and IF functions
16. (46:33) SEQUENCE & COUNTIFS functions to build Assembly Lime Time Report.
17. (49:13) MAXIFS and MINFS functions to build ab Assembly Line Max and MIN Time Report
18. (50:50) Summary
19. (51:39) Practice Problems for you!
20. (51:46) Closing and video link

excelisfunMon, November 11, 2024 2:11pm