Excel Formula to Create Cross Tabulated OR & AND Logical Test Sales Total

Posted on by Annie D

Excel Formula to Create Cross Tabulated OR & AND Logical Test Sales Total

Download File:
Start File: http://ift.tt/2rKDr8N
Finished File: http://ift.tt/2sjWh3G
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
See how to use SUMIFS and SUMPRODUCT Functions to create a Cross Tabulated Table to add Sales with Sales Channel Criteria as the Row Header Criteria and Product Group OR Criteria as the Column Header Criteria.
Related Videos:
Excel Magic Trick 1439: DAX Formula to Create Cross Tabulated OR & AND Logical Test Sales Total
Excel Magic Trick 1438: Excel Formula to Create Cross Tabulated OR & AND Logical Test Sales Total
via YouTube https://youtu.be/KI0JQQuBJZc