DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Formulas to Sum the Lowest N values from a Range in Excel!!

In this tutorial, we will explain you to learn the simple and useful Formulas to sum the lowest N values from a range in Excel Office 365. Let’s see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Formulas to sum the lowest n values
Formulas to sum the lowest n values

General Formula:

  • In Excel, the below formula will help to sum the lowest values from a range.

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

Syntax Explanations:

  • SUMPRODUCT – This function will help to multiply the corresponding arrays or ranges and returns the sum of the products. Read more on the SUMPRODUCT Function.
  • SMALL – The SMALL Function will return the Nth smallest value from the given range of data.
  • Comma symbol (,) – It is a separator which helps to separate a list of values.
  • Parenthesis () – The main purpose of this symbol is to group the elements.
  • Range – It represents the input range from your workbook.
  • Criteria(n) – It is the number of the lowest values to sum.

Example:

  • Now we are going to see the step-by-step procedure to sum the lowest n values from a range.
  • Refer to the below image.
  • First, we will give the input values in Column B.
  • Then, enter the given formula in the selected area.
  • Finally, it displays the result as per the below image.

Example
Example

Wind-Up:

From this article, we explained the simple formula used to sum the lowest N value from a range in Excel Office 365. Hope you like this article. If you have any doubts, don’t forget to share it with us. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!! *and Excel Formulas *!!

Read Ahead:

Top comments (0)