Download Excel File: https://excelisfun.net/files/EMT1669.xlsx
Learn how to summarize Book Author Sales Units when there are multiple authors for each book and only Book ID in the Sales Table, not Author ID. Learn how to create OR Logical Tests in a number of different ways. Learn how to use FILTER, IF and MMULT to create the OR Logical Test Criteria inside the SUMIFS Function.
Topics:
1. (00:01) Introduction and Overview of logic for formula
2. (01:00) Formula #1: FILTER, SUMIFS, SUM and Direct Array OR Logical Test calculations.
3. (04:19) Formula #2: IF , SUMIFS, SUMPRODUCT and Direct Array OR Logical Test calculations.
4. (05:03) Formula #3: FILTER, MMULT, COLUMN, SUMIFS, SUM and Direct Array OR Logical Test calculations.
5. (05:39) Summary and End Video Links