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 mode. The mode is the number of the most frequently occurring or repetitive values in a data range.
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 mode.
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 mode, please use the following formula:
=SUMIF(C2:C12,">"&MODE(C2:C12))
The mode is $84,923.00, and the total above the mode returns $272,919.00.
Formula 2: To get total salaries less than the mode, please use the following formula:
=SUMIF(C2:C12,"<"&MODE(C2:C12))
The mode is $84,923.00, and the total less than the mode 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.