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

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

DOWNLOAD WORKBOOK

 

 

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

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