Double OR Logical Tests in SUMIFS Function using FILTER or IF or MMULT. Excel Magic Trick 1669.
Автор: excelisfun
Загружено: 2020-05-16
Просмотров: 24138
Download Excel File: https://excelisfun.net/files/EMT1669....
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
