This function returns the maximum value among the values in cells or the cell range provided the specified set of conditions or the criteria meets.
MAXIFS(max_range, range1, criteria1, [range2,criteria2],..)
This function has the following arguments:
Argument | Description |
---|---|
max_range | Refers to the range of cells in which maximum will be calculated |
range1 | Refers to the set of cells to be calculated based on the criteria |
criteria1 | Refers to the criteria (in terms of number, expression, or text) according to which cells will be calculated |
range2, criteria2... | [Optional] Refers to the additional ranges and their corresponding criteria |
If the size and shape of max_range and rangeN (refers to range1,2,3,4,......N) arguments is not same, this function will return the #VALUE! error.
If cells do not match with the specified criteria, this function will return 0.
Accepts either numeric data, expression, or text for all arguments. Returns numeric data.
MAXIFS(C4:C7,B4:B7,"325") gives the result 656
MAXIFS(C4:C7,B4:B7,"55") gives the result 0