What makes the SUMPRODUCT function even more powerful is its ability to nest formulas, or in simple terms, add another function within the SUMPRODUCT function.

Instead of getting the Total Sales for a region, we can extract the Maximum sales value simply by entering the MAX function before the criteria.  See how below.

DOWNLOAD WORKBOOK

Advanced Sumproduct_Maximum Sales

Helpful Resource:

excel-formula-crash-course-from-chandoo.org

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Cleaning Data with Excel’s TRIM Formula What does it do? Removes unneeded spaces in your text, except single spaces in between words Formula breakdown: =TRIM(text) What it means: =TRIM(text that you want extra spaces to be removed) In the quest for cleaner data, one of the common scenarios is remo...
SUMIFS Function: Introduction The SUMIFS function allows you to Sum multiple criteria. For example, you can select one Sales Rep from a list of Sales Reps and select one Region from a list of Regions and return the Sum of those arguments from a Sales list.  See how easy it is... DOWNLOAD WORKBOOK ...
Highlight All Excel Formula Cells Whenever you are auditing an Excel worksheet and need to know where all the formulas are located, a great way is to highlight the formula cells in a distinctive color.  This is how it is done: 1.Select all the cells in your Excel worksheet by clicking on the top left hand corn...
Match Two Lists With The MATCH Function I am sure that you have come across many occasions where you have two lists of data and want to know if a specific item in List1 exists in List2. Well I have! With the MATCH function you can verify if a cell´s item in List1 exists in List2. The function will return the r...