MAXIFS Function Explained
The MAXIFS Function in Microsoft Excel is used to find the maximum value in a range of cells, based on multiple criteria. It takes up to 127 arguments, with the first argument being the range of cells to be evaluated, followed by 2 to 127 pairs of criteria range and criteria. The function returns the maximum value in the range that meets all of the criteria.
MAXIFS Function Syntax
MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
- max_range: The range of cells to be evaluated for the maximum value.
- criteria_range1: The range of cells to be evaluated by the criteria1.
- criteria1: The criteria in the form of a number, expression, cell reference, or text that defines which cells will be added.
- criteria_range2, criteria2: (Optional) Additional ranges and their associated criteria. Up to 126 range/criteria pairs are allowed.