Courses
SUMIFS Function
Return value
Returns sum of all values in the sum range for the rows that matches the criteria in criteria ranges.
Syntax
= SUMIFS(sum_range; criteria_range1; criteria1; ...)
Arguments
| Argument | Description |
|---|---|
| sum_range | The range to sum up values from. |
| criteria_range1 | The range to check if criteria1 matches. |
| criteria1 | The criteria to match in the criteria range. |
| [criteria_range…n] | [Optional]: Up to the limit of 127 of criteria ranges. |
| [criteria…n] | [Optional]: Up to the limit of 127 of criteria. |
Remarks
SUMIFS is the Table equivalent of the sum functionality in Pivot Tables.
Tip: Use SUMIFS instead of SUMIF
Instead of using SUMIF that can only handle one criteria, use SUMIFS that can handle one or many criteria.