Summing the X Maximum Values in an Array

An Excel file that teaches how to perform Summing the X Maximum Values in an Array operation.

Excel Source: Summing the X Maximum Values in An Array

The first X value is determined using the SUM function. Multiple selections are made using the array formula. The total is obtained using the SUM function. Blank cells are not included in the calculation. The report area is automatically updated.

Hope it is useful.