Excel Function : MAXIFS
Category
Statistical
Description
Returns the maximum value among cells specified by a given set of conditions or criteria
Microsoft Excel Reference Page
https://support.office.com/en-us/article/MAXIFS-function-dfd611e6-da2c-488a-919b-9b6376b28883
Syntax and Description of the MAXIFS Excel Function
The MAXIFS function in Excel returns the maximum value from a range of cells that meet multiple criteria. The syntax for the MAXIFS function is: MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) where max_range is the range of cells to return the maximum value from, criteria_range1 is the first range of cells to evaluate for the criteria, criteria1 is the criteria to evaluate for in the first range, and so on.
About MAXIFS Excel Function
The MAXIFS function returns the maximum value from a range, based on multiple criteria.
