Pinterest Pixel

Advanced SUMPRODUCT Function: Maximum Sales

Advanced SUMPRODUCT Function: Maximum Sales What makes the SUMPRODUCT function even more powerful is its ability to nest... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

Advanced SUMPRODUCT Function: Maximum Sales | MyExcelOnline Advanced SUMPRODUCT Function: Maximum Sales | MyExcelOnline

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

 

 

If you like this Excel tip, please share it
Advanced SUMPRODUCT Function: Maximum Sales | MyExcelOnline Advanced SUMPRODUCT Function: Maximum Sales | MyExcelOnline

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!

Share to...