SUMIFS

The SUMIFS function calculates the total value of cells in a range that meet multiple criteria.

=SUMIFS(E$2:E$13,C$2:C$13,"Account Rep",B$2:B$13,"Atlanta")

=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2...)

SUM_range
The sum_range argument designates the cells containing values to add if the condition is met. In the SUMIFS function, the sum_range argument is the first argument, instead of the last argument as in the SUMIF function.

Criteria_range1
The range argument specifies the first range of cells you want to evaluate to see if the values meet a particular condition. The range must contain values, range names, arrays, or references that contain numbers, dates, or text.

Criteria1. The criteria1 argument specifies the condition for the criteria_range1 argument that imposes limitations on what values are summed.

Criteria_range2. The range argument specifies the second range of cells you want to evaluate to see if the values meet a particular condition. The range must contain values, range names, arrays or references that contain numbers, dates or text.

Criteria2. The criteria2 argument specifies the condition that imposes limitations on what values are summed.