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.

Formula:

How the formula works

The formula used is:

=SUMPRODUCT(SMALL(A4:A9,{1,2,3}))

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.

Result:

 

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