Pinterest Pixel

Advanced SUMPRODUCT Function: Maximum Sales

John Michaloudis
Free Practice Workbook
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.
Advanced SUMPRODUCT Function: Maximum Sales | MyExcelOnline Advanced SUMPRODUCT Function: Maximum Sales | MyExcelOnline

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
LinkedInCopyPrintReddit
Advanced SUMPRODUCT Function: Maximum Sales | MyExcelOnline
Founder & Chief Inspirational Officer at

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 MyExcelOnline Academy Online Course.

See also  Advanced SUMPRODUCT Function: Conditional Date

Steps To Follow

Excel Formulas & Functions TutorialsExcel Math FormulasSUMPRODUCT Formula in Excel

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...
BufferCopyFlipboardHacker NewsLineLinkedInMastodonMessengerMixPinterestPocketPrintRedditSMSTelegramThreadsTumblrVKWhatsAppXingYummly