To get the sum of all numbers, you can use the SUM function. You use the SUMIF function to get the sum of the numbers that are greater than or equal to a number.
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 greater than or equal to $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 that are greater than or equal to $80,000, please use the following formula:
= SUMIF(C2:C11,">=80000")
The result returns $724,000.00
Formula 2: To get the total salaries for those 40 years old or over, please use the following formula:
= SUMIF(B2:B11,">=40",C2:C11)
The result returns $158,000.00
Formula 3: To get the total salaries for those greater than or equal to C6, please use the following formula:
= SUMIF(C2:C11,">="&C6)
The result returns $643,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.