EXCEL SUMIFS

The Sumif is an Excel function to sum the values in a range based on one or more criteria.

Syntax:

=Sumif(sum_range,criteria_range1,criteria1,………..)

Arguments or Parameters:

sum_range: a range of cells that should be summed together.
criteria_range1: a range of cells to apply criteria.
criteria1: Criteria1 to be applied to the criteria range.

Objective: Find the total sales of Dell Products done by Barry Johnson in cell I3.

Step 1:

Type = sign in cell I3
Type Sumifs Function

Step 2:

Select range E2:E22
Type “,”

Step 3:

Select C2:C22 in Criteria range1
Type “,”
Type G3 in Criteria1

Step 4:

Select range D2:D22 in criteria range2
Type “,”
Type H3 in Criteria2
Close bracket with “)”
Press Enter

Conclusion: The Sumifs formula has given the sum of values of Dell with Barry Johnson as 515 in cell I3.