SUMIFS Function Explained
The SUMIFS Function in Microsoft Excel is used to sum up values in a range of cells that meet multiple criteria. It takes up to 127 range/criteria pairs as arguments, and returns the sum of the corresponding values in the specified range.
SUMIFS Function Syntax
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
- sum_range: The range of cells to be summed.
- criteria_range1: The range of cells to be evaluated for the first criteria.
- criteria1: The criteria in the form of a number, expression, cell reference, or text that defines which cells in the criteria_range1 argument will be added.
- criteria_range2: (optional) The range of cells to be evaluated for the second criteria.
- criteria2: (optional) The criteria in the form of a number, expression, cell reference, or text that defines which cells in the criteria_range2 argument will be added.