The SUMIFS function adds all the numbers with multiple criteria you specified.
Formula:
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
Explanations:
– Sum_range is required, the range to sum.
– Criteria_range1 is required, the range for the first criteria to meet.
– Criteria1 is required, the first criteria to meet.
– Criteria_range2 is optional, the range for the second criteria to meet.
– Criteria2 is optional, the second criteria to meet.
Cautions:
– Wildcard characters (the question mark ?) and (asterisk *) can be used in the criteria argument.
Example: what is the total income for Male and over $80,000?
=SUMIFS(B2:B11, B2:B11, ">80000", A2:A11, "M")
The result returns $261,000.