SUMIF Function

SUMIF Function calculates a sum of values in a range only when related data meet a specific condition instead of calculating the sum of an entire range.

For example, if you want to calculate the total salaries for all Account Reps, you cannot use the SUM function because it calculates the total salaries for all employees. However, you can use the SUMIF function to do this.

=SUMIF(C2:C13,"Account Rep", E2:E13)
=SUMIF(range, criteria, sum_range)

Range. The Range argument specifies the range of cells you want to evaluate to see if the values meet a particular condition.
Criteria. The criteria argument specifies the condition that imposes limitations on what values Excel sums. The criteria can be a value, date, text, or another cell containing a value, date, or text.
Sum_range. The sum_range argument designates the cells containing values to add if the condition is met.