Explainry Tutorials to Expert in IT

Sum bottom n values

To sum bottom n values, use the combination of the SUMPRODUCT and the SMALL functions. In our example, we will sum bottom three values.


How the formula works

The formula used is:


where, the SMALL function is used against array1, which is an argument of the SUMPRODUCT function, and, the arguments of the SMALL functions are:

array (A4:A9) – The range of cells from which you want to find k-th smallest value,

k {1,2,3} – The position of the desired smallest value in the range of cells, e.g. in 2nd smallest, 2 is k.



Copyright © 2016 - 2020 Explainry.com | All Rights Reserved