IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation? EMT 1746

Posted on by Bb

Download Excel File: https://excelisfun.net/files/EMT1746.xlsx
Learn how to create an OR Logical Test to make an aggregate calculation depending on whether the test involves one column or two columns. Learn about the SUMIFS, FILTER and IF functions to help run an OR logical Test to make an aggregate calculation.
In this video:
1. (00:00) Introduction
2. (00:14) OR Logical Test Question on 1 Column
3. (00:26) OR Logical Test Question on 2 Columns
4. (00:46) SUMIFS and SUM functions to add sales where OR logical Test works on 1 column.
5. (02:03) SUM and FILTER functions to add sales where OR logical Test works on 2 columns. Microsoft 365 Excel formula.
6. (02:28) OR Logical Test with Plus Math Operator.
7. (03:05) what the 0s, 1s and 2s mean in an OR Logical Test.
8. (04:05) SUM and IF functions to add sales where OR logical Test works on 2 columns. Works in any version of Excel.
9. (05:17) Keystroke Ctrl + Shift + Enter.
10. (05:40) Why not use SUMPRODUCT?
11. (06:22) NOT Logical Test inside SUMIFS function.
12. (07:09) Universal formula for OR Logical Test in an Aggregate Calculation.
13. (07:35) Compare Two Lists Logical Construction to run OR Logical Test on 1 column.
14. (08:04) 1 Column Or Logical Test with Function Argument Array Operation works on the aggregate calculations: sum, count, min, max. It will not work on average.
15. (08:36) FILTER will work in any Aggregate Function, including AVERAGE and 2 column OR Logical Tests.
16. (08:45) Conclusion and Summary, Video Links and Outro

ExcelIsFunMon, August 9, 2021 9:08am