Excel Magic Trick 1438

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


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.


Download “Excel Magic Trick 1436-1440” Excel-Magic-Trick-1436-1440.zip – Downloaded 557 times – 81 MB

Be the first to comment

Leave a Reply