Use MAXIFS and MINIFS in **Excel 2016** or later to find the maximum and minimum value based on one criteria or multiple criteria.

1. For example, the MAXIFS function below finds the highest female score.

Note: the first argument (D2:D12 in this example) is always the range in which the maximum or minimum will be determined. This MAXIFS function has 1 range/criteria pair (B2:B12/Female).

2. The MINIFS function below finds the lowest female score.

3. For example, the MAXIFS function below finds the highest female score in Canada.

Note: this MAXIFS function has 2 range/criteria pairs (B2:B12/Female and C2:C12/Canada). MAXIFS and MINIFS functions can handle up to 126 range/criteria pairs.

4. The MAXIFS function below finds the highest score below 60.

Note: this MAXIFS function only uses the range D2:D12.