Pinterest Pixel

Advanced Sumproduct Function: Sum the Top 3 Sales with an Array Formula

Advanced Sumproduct Function: Sum the Top 3 Sales with an Array Formula This is probably the most... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

Advanced Sumproduct Function: Sum the Top 3 Sales with an Array Formula | MyExcelOnline Advanced Sumproduct Function: Sum the Top 3 Sales with an Array Formula | MyExcelOnline

Advanced Sumproduct Function: Sum the Top 3 Sales with an Array Formula

This is probably the most advanced level a SUMPRODUCT function can reach and that is by including a nested array formula.

In our example below we want to return the 3 Largest values from the North region and sum them up.  As we are asking our formula to perform multiple calculations i.e. Get the Largest 3 values or large((array,{1,2,3}), then an array formula is used.  So to make this formula work we need to finish it off by pressing CTRL+SHIFT+ENTER

download workbookAdvanced-Sumproduct_Top-3-Sales-with-an-Array-Formula.xlsx

 

 

If you like this Excel tip, please share it
Advanced Sumproduct Function: Sum the Top 3 Sales with an Array Formula | MyExcelOnline Advanced Sumproduct Function: Sum the Top 3 Sales with an Array Formula | 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...