COUNTIFS & SUMIFS functions: When you CAN and CANNOT Spill Results. LAMBDA too. EMT 1777

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1777.xlsx
Learn about the situations where you can spill results from SUMIFS, COUNTIFS, MINIFS, MAXIFS and AVERGAEIFS.
Learn how to.
1. (00:00) Introduction
2. (00:50) COUNTIFS function example that CANNOT Spill
3. (01:44) COUNTIFS function example that CAN Spill
4. (02:55) Spilling aggregate functions that need to iterate across a table with BYROW and LAMBDA functions.
5. (06:21) SUMIFS function example that CANNOT Spill. Learn about SUMIFS “Not Empty” syntax.
6. (08:08) SUMIFS function example that CAN Spill
7. (08:50) Spilling aggregate functions that need to iterate across a table with BYROW and LAMBDA functions.
8. (09:34) Summary
9. (01:25) Example of Single Cell Report that spills from one cell
10. (10:34) Closing and Video Links

ExcelIsFunMon, March 7, 2022 9:17pm