Site icon ExcelNotes

How to Use SUMIFS Function

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.

Download: SUMIFS Function

Exit mobile version