Site icon ExcelNotes

How to SUM Numbers Greater than

In mathematics, greater than is used to express that some values are more than others, and the greater than symbol is ">". You can use the SUMIF function to have the sum of cells greater than a value (e.g., >$80,000).

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 over $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 over $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 over 30 years old, please use the following formula:

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

The result returns $598,000.00

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

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

The result returns $561,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.

Exit mobile version