The MAXIFS function was introduced with Excel 2016. It allows the user to retrieve the largest numerical value dependent upon criteria in other columns or the column where the maximum is being retrieved.
