How To Use MaxIfs and MinIfs in Excel
This function combines the MAX and IF function in order to get the maximum value in a data set of Excel worksheet. To look up the maximum value in a range based on specific criteria, you can use a basic array formula based on the IF function. {=MAX(IF(criteria_range=criteria,value_range))} Use the MAXIFS and MINIFS function in Excel …