How to SUM Numbers Less than

To get the sum of all numbers, you can use the SUM function. If you need to get the sum of the numbers that are less than a number, please use the SUMIF function.

Example: You are working with data that includes the employee's gender, age, and salaries, and you need to get the sum of the salaries that are less than $80,000.

The employee's gender is in column A, the age is in column B, and the employees' salaries are in column C.

Formula 1: To get total salaries less than $80,000, please use the following formula:

= SUMIF(C2:C11,"<80000")

The result returns $156,000.00

Formula 2: To get the total salaries for those less than 30 years old, please use the following formula:

= SUMIF(B2:B11,"<30",C2:C11)

The result returns $99,000.00

Formula 3: To get the total salaries for those less than cell C6, please use the following formula:

= SUMIF(C2:C11,"<"&C6)

The result returns $237,000.00

Notes: The SUMIF function

The SUMIF function adds all the numbers with the criteria you specified.

Formula:

=SUMIF(range, criteria, [sum_range])

Explanations:

– The range is required, which is the criteria range.
– The criterion is required, the criteria for the sum.
– Sum_range is optional, the cells to add together.

Leave a Reply