Find the maximum value in a range using criteria.

`MAXIFS(max_range, criteria_range1, criteria1, criteria_range2, criteria2, ...)`

- max_range - the actual range of cells to determine the maximum in
- criteria_range1 - the set of cells to be evaluated with the criteria
- criteria1 - the criteria that defines which cells to evaluate as maximum
- criteria_range2, ... [OPTIONAL] - additional ranges and their associated criteria

`=MAXIFS(D5:D16,C5:C16,"F")`

The MAXIFS function can be used to find the maximum value in a range of cells, when one or more criteria are true. For example, this returns the maximum value in the range D5:D16 where the corresponding cells in C5:C16 are equal to "F" (93).

`=MAXIFS(D5:D16,C5:C16,"M")`

The MAXIFS function can also be used to find the maximum value in a range of cells when the criteria is a string. For example, this returns the maximum value in the range D5:D16 where the corresponding cells in C5:C16 are equal to "M" (83).

`=MAXIFS(A1:A100,B1:B100,">50")`

The MAXIFS function can also be used to find the maximum value in a range of cells when the criteria is a comparison operator. For example, this returns the maximum value in the range A1:A100 when the corresponding cells in B1:B100 are greater than or equal to 50.

The MAXIFS function is a powerful tool that allows users to quickly find the maximum value in a set of cells when given a set of conditions or criteria. It works on both Windows and Mac systems.

- MAXIFS is a Sourcetable function that requires a cell range for range arguments.

The MAXIFS function is used to return the maximum value from a set of cells based on a set of conditions or criteria.

Yes, the MAXIFS Function is available on both Windows and Mac with either Office 2019 or a Microsoft 365 subscription.

The MAXIFS function requires at least Office 2019 or a Microsoft 365 subscription in order to use it.

- The max_range and criteria_range1 arguments must be the same size and shape.

Drop CSV