Excel Yourself: LARGE and SUMPRODUCT functions

Excel Yourself

Very few users are aware of the LARGE function, which lets you specify the position you want to extract. 

While the MAX function allows you to extract the highest value in a range, the LARGE function lets you specify the position you want to extract.

The SUMPRODUCT function is Excel's most flexible function and can perform calculations that are usually only possible with array formulas.
Want to learn more about how these two functions work together? Download the sample Excel file and check out our video tutorial.

Neale Blackwood CPA runs A4 Accounting, providing Excel training, webinars and consulting services.

For more on the LARGE and SUMPRODUCT functions, visit the February 2013 issue of INTHEBLACK magazine.

How-to articles, sample spreadsheets and more

Excel yourself

Combine annual and monthly data in Excel with these simple steps

Making data relationships work

Easy steps to make data Relationships work in Excel

Excel Yourself

Easy tips for matching salary to job class in Excel