Free Practice WorkbookTable of Contents
Advanced SUMPRODUCT Function: Maximum Sales
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 workbookAdvanced-Sumproduct_Maximum-Sales.xlsx
John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.
30 Days - Full Access 
