Pinterest Pixel

Advanced SUMPRODUCT Function: Maximum Sales

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

Download Excel Workbook
John Michaloudis
Posted on

Overview

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.

Advanced SUMPRODUCT Function: Maximum Sales | MyExcelOnline
download workbookAdvanced-Sumproduct_Maximum-Sales.xlsx

 

 

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

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!