Summing the Smallest X Values in a Range

An Excel file that teaches how to perform Summing the Smallest X Values in a Range operation.

Excel Solution: Summing the Smallest X Values in A Range

The first X value is found using the SMALL function. The array formula is applied sequentially. The result is calculated using the SUM function. Blank rows are ignored. The result is displayed in the table in an orderly manner.

Hope it is useful.