Excel Forum

Excel Array Formula Series #5: SUM 3 Largest Values

See how to create array formula for adding the 3 largest or smallest values in a data set. This is a great trick for scoring the Maximum Time Aloft Boomerang event.

Array Formulas: Add the 3 highest values
Remember to enter array formula with Ctrl + Shift + Enter
The formula is: SUM(LARGE(D11:H11,{1,2,3}))

In this series see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and reduce them down to a single formula that sits in just one cell! You will see how to create array formulas and see how to use Array Functions.

Got a Question? Ask it Here in the Forum.