SUMIF function

The SUMIF function adds cells specified in range by a certain condition or criteria.

The Syntax for SumIF Function:

=sumif(range,criteria,[sum_range])

Range: A range is a range of cells you want to apply a specific criteria against.

Criteria: The criteria determines which cells to add.

Sum_range: Cells to sum.

Example:

The following example shows how to properly use the SumIf Function. Basically, we are using the SumIf function in Cell D3 to determine how many runs the Tigers scored in Home. The example uses the range A3:A12. The SumIf function matches the word “Home” in the range A3:A12 then adds the runs in the Sum_range B3:B12. Since our criteria is “Home,” the SumIf function ignores all of the away games.

Other Examples:

=SUMIF(A3:A12,C3,B3:B12) —– The SumIf Function returns: 20

=SUMIF(A3:A12,”Home”,B3:B12) —– The SumIf Function returns: 20

=SUMIF(A3:A12,”Away”,B3:B12) —– The SumIf Function returns: 13