Excel Magic Trick 1368

How To get SUMIFS to Calculate Sum Of Amazon And Google Under Each Region

DESCRIPTION

See how to use the SUMIFS and SUMPRODUCT functions to Calculate Sum Of Amazon And Google Under Each Region. Properly you will learn about OR Logical Tests and AND Logical Tests so that we can ask the correct question as: “How to Add Sales for ‘Amazon OR Google’ AND West”. Learn how to make a Function Argument Array Operation in the criteria argument of SUMIFS to get SUMIFS to calculate an OR Logical Test (OR Criteria) as well as the default AND Logical Test (AND Criteria). See how to use SUMPRODUCT to add the results of an Array Operation, rather then the SUM Function.

WORKBOOKS

Download “Excel Magic Trick 1361-1380” Excel-Magic-Trick-1361-1380.zip – Downloaded 458 times – 14 MB







Be the first to comment

Leave a Reply