Using the SUMIF function, you can get the sum of numbers that meet one criterion, such as great than a number, the average, or the median. The median is the number in the middle of a set of numbers.
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 the median.
The employee's first name is in column A, the last name is in column B, and the employees' salaries are in column C.
Formula 1: To get total salaries greater than the median, please use the following formula:
=SUMIF(C2:C12,">"&MEDIAN(C2:C12))
The median is $79,058.00, and the total above the median returns $442,765.00.
Formula 2: To get total salaries less than the median, please use the following formula:
=SUMIF(C2:C12,"<"&MEDIAN(C2:C12))
The median is $79,058.00, and the total less than the median returns $317,574.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.
