IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation? EMT 1746
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
Видео IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation? EMT 1746 канала ExcelIsFun
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
Видео IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation? EMT 1746 канала ExcelIsFun
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)](https://i.ytimg.com/vi/evrnIuDRtsQ/default.jpg)
![Double OR Logical Tests in SUMIFS Function using FILTER or IF or MMULT. Excel Magic Trick 1669.](https://i.ytimg.com/vi/v14i4qSmZTo/default.jpg)
![Using Excel’s Wildcards with the FILTER Function](https://i.ytimg.com/vi/s32WJJ1IP7w/default.jpg)
![How to Sum Values If a Cell Contains a Specific Text | SKYXCEL](https://i.ytimg.com/vi/8cQigOtjBSE/default.jpg)
![Amazing Excel FILTER Function + Trick to Rearrange Column Order](https://i.ytimg.com/vi/ZCQAweoAdOw/default.jpg)
![How to SUMIFS With Multiple Criteria In the SAME Column in Excel](https://i.ytimg.com/vi/3BnvDPQk9o0/default.jpg)
![Excel FILTER Function TRICK for Non Adjacent Columns](https://i.ytimg.com/vi/Onudkw9DMlU/default.jpg)
![](https://i.ytimg.com/vi/8qpVKiMiWmU/default.jpg)
![How to Calculate Working Days in Excel & Exclude ANY Days you WANT (weekends too)](https://i.ytimg.com/vi/Wyoo9mQPxCY/default.jpg)
![Count Visible Rows in a Filtered List in Excel - EQ 99](https://i.ytimg.com/vi/lTSg9ruV41U/default.jpg)
![Excel FILTER Function to Return Non-Adjacent Columns in Any Order](https://i.ytimg.com/vi/2jxS_0qQHlA/default.jpg)
![How To Use Excel COUNTIFS With Multiple Criteria And OR Logic || Excel Tricks || dptutorials](https://i.ytimg.com/vi/-T65zuozSeA/default.jpg)
![How to Use AGGREGATE for MIN IF Formula with Multiple Criteria (Part 5 of 5)](https://i.ytimg.com/vi/NJFCd3HimXc/default.jpg)
![Get the Sum of Filtered Data in Excel (Using SUBTOTAL Formula)](https://i.ytimg.com/vi/_Jxm6WINkfQ/default.jpg)
![Excel Sum(ifs) between dates, sum month & sum with multiple criteria](https://i.ytimg.com/vi/XIhbL20jTHc/default.jpg)
![Excel AGGREGATE Function (Multiple Criteria with Examples)](https://i.ytimg.com/vi/ZXkChkkWY8g/default.jpg)
![4 Types of Criteria for SUMIFS & COUNTIFS - Excel Magic Trick 1564, SUMIF & COUNTIF too](https://i.ytimg.com/vi/Wh9wHVzMhCw/default.jpg)
![Excel Lookup to Return Multiple Values with FILTER Function](https://i.ytimg.com/vi/Eehk6PC0oGs/default.jpg)
![MrExcel's Learn Excel #946 - Countif Filtered](https://i.ytimg.com/vi/ItotSyqA3XI/default.jpg)
![Advanced Excel Filter (And, Or, Between conditions for criteria range)](https://i.ytimg.com/vi/VqQACB_69SQ/default.jpg)