SUMIF Function

Function SUMIF

Adds the cells specified by a given criteria.

 SUMIF(range,criteria, sum_range)

Range  is the number of cells to count – in this example, C2 to C22

Criteria  is the criteria we specify to define which cells will be added – here, we specify the criteria as “>125000” i.e,  any cell containing a number greater than 125000 are added to get the sum.

Sum_range are the actual cells whose data is being summed up only if their data matches with the criteria specified. If this is not mentioned, the range specified in the “range” is considered and their data is summed up if the criterion is matched. Here the sum_range is F2 to F22

The answer therefore is 2129508.30

Another example of the SUMIF function using text – the criteria being “Attorney” where the cells containing the data “Attorney” are being considered and their salaries are summed up. The answer for this is 1252372.15. Notice that the range has changed from “C” cells to “B” cells.

 .