How to Sum If Less Than in Excel

To sum values in Excel if they are less than a specific number, you can use the SUMIF function. SUMIF allows you to add up the values in a range that meet a certain criterion.

Here's a step-by-step guide on how to use SUMIF to sum values less than a specific number:

1. Prepare your data in Excel. Organize your data in columns, with one column containing the values you want to sum and another column containing the criteria you want to use (in this case, the specific number).
2. In an empty cell, type the following formula:

=SUMIF(range, "<" & criteria, [sum_range])

• range: The range of cells you want to apply the criteria to.
• criteria: The specific number you want to compare the values to.
• sum_range: The range of cells containing the values you want to sum. If not provided, Excel will assume the range contains the values to sum.

3. Replace the range, criteria, and sum_range in the formula with the appropriate cell references or values.
4. Press Enter to get the result.

Example

Let's say you have the following data in Excel:

You want to sum the values in column A that are less than 20. Here's how to do it using the SUMIF function:

1. In an empty cell, type the following formula:

=SUMIF(A1:A4, "<20")

2. Press Enter. The result (25) will be displayed in the cell, as 10 + 15 = 25, and both 10 and 15 are less than 20.

If you want to sum the values in column B based on the criteria in column A, you can use the following formula:

=SUMIF(A1:A4, "<20", B1:B4)

Press Enter. The result (26) will be displayed in the cell, as 24 + 2 = 26, since 10 and 15 from column A are less than 20, and their corresponding values in column B are 24 and 2, respectively.