SUMIFS adds values that meet multiple criteria. The first parameter is the range to sum , second is the range the criteria is applied to, and the third is the criteria. Add parameters for additional criteria ranges and criteria.
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...).
Example 1: Total values within A1 and A4 if they are between 100 and 200:
=SUMIFS(A1:A4,A1:A4,">100",A1:A4,"<200")
Example 2: Total values within C1 and C4 if Yes is in column A, and Yes is also in column B:
=SUMIFS(C1:C4,A1:A4,"Yes",B1:B4,"Yes")
For more info, see SUMIFS function.
SUMIFS adds values that meet multiple criteria. The first parameter is the range to sum , second is the range the criteria is applied to, and the third is the criteria. Add parameters for additional criteria ranges and criteria.
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...).
Example 1: Total values within A1 and A4 if they are between 100 and 200:
=SUMIFS(A1:A4,A1:A4,">100",A1:A4,"<200")
Example 2: Total values within C1 and C4 if Yes is in column A, and Yes is also in column B:
=SUMIFS(C1:C4,A1:A4,"Yes",B1:B4,"Yes")
For more info, see SUMIFS function.
