## DEV Community is a community of 553,934 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

# Excel Formulas to Sum the Values that are Less than a Certain Value!! Andrews Originally published at geekexcel.com on ・2 min read

This page will explain the simple formulas used to sum the values in the cells that are less than a certain value 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 ## General Formula:

• Use the below formula to sum the values in the cells that are less than a particular value.

=SUMIF(range,”<criteria”)

## Syntax Explanations:

• SUMIF – The Excel SUMIF Function will help to sum the cells that meet a single condition or criteria.
• 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 values given in the worksheet.
• Criteria – It is the specific value or criteria that helps to sum the values.
• Operator (<) – This symbol is used to find the values which are less than a certain value.

## Example:

• Now we are going to see how to sum the values that are less than a particular number.
• Refer to the below image.
• Here, we will give the input values in Column C.
• After that, enter the given formula in the selected field.
• Finally, it displays the result in cell F3. 