Excel Forum
Similar Content
Convert Numbers into True and False in Excel
Tutorial: How to convert numbers into the TRUE and FALSE Boolean values in Excel. This is very impor...
Sum Values from Every X Number of Rows in Excel
Tutorial: Add values from every x number of rows in Excel. For instance, add together every other va...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...

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.