Excel Formulas to Sum the Lowest N values from a range with Criteria!!

Here, we will discuss the Formulas to sum the lowest N values from a range with criteria in Excel Office 365. Let’s get into this article!! 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 with criteria

General Formula:

• To sum the lowest N value from a range with certain criteria in Excel, use the below formula.

=SUM(SMALL(IF(range1=criteria,range2),{1,2,3,N}))

Syntax Explanations:

• SUM – In Excel, this function will help to add the values in the cells. Read more on the SUM Function.
• SMALL – The SMALL Function will return the N^th smallest value from the given range of data.
• IF – The Excel** IF function** return one value for a TRUE result, and another for a FALSE result.
• 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 – It is the condition that is used to sum the values.

Example:

• In the below example, we are going to see how to sum the lowest N values with criteria.
• First, we will give the input values in Column B and Column C.
• Then, apply the given formula in the selected area.
• After that, Press (CTRL+SHIFT+ENTER) keys.
• Finally, we will get the result in the selected Cell F3.

Example

Closure:

In this short tutorial, we described the simple formulas used to sum the lowest N values from a range with criteria in Excel Office 365. Hope that this article is useful to you. Don’t forget to share your worthwhile feedback. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!! *and Excel Formulas *!!

Read Ahead:

• Excel Formulas to Count Rows that meet Multiple OR Criteria!!
• Formulas for Counting Cells with Multiple OR Criteria in Excel 365 !!
• Formulas to Count the Rows that meet Multiple Internal Criteria in Excel!!