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 greater than or equal to 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 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.