Learn How to SUM Bottom n Values in Microsoft Excel

SUM Bottom n Values in Microsoft Excel

The main purpose of this formula is to sum the lowest n values in a range. Here we will learn how to sum the bottom n values in Microsoft Excel. That implies, with the help of a formula based on the  SMALL an AGGREGATE function you can able to sum the lowest n values in a range. It should be noted that the generic form of the formula provided here, rng represents a range of cells that contain numeric values and n represents the number of lowest values to sum So, with the help of this formula, you can able to sum the bottom n values in the Microsoft Excel.

General Formula to SUM Bottom n Values

=SUMPRODUCT(SMALL(rng,{1,2,n}))

The Explanation for the SUM Bottom n Values

So we know that with the help of the given formula above you can able to sum the lowest n values in a range. Here we will learn how to sum the bottom n values in Microsoft Excel. As we know that the in the simplest form, the SMALL function will return the "nth smallest" value in a given range. But in case, you supply an array constant that is a constant in the form - 1,2,3, to SMALL function as the second argument, it will return an array of results instead of a single result So, with the help of this formula, you can able to sum the lowest n values in a range.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel