Excel Magic Trick 1438

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

DESCRIPTION

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.

WORKBOOKS

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







Be the first to comment

Leave a Reply