When will start looking for advice how to make Max If formula in MS Excel, most of the time you will get this example:
{=MAX(IF(criteria_range=criteria, value_range))}
Where those curly brackets mean that this formula is an array formula. And while it is only one IF criteria, formula look fine. But lets add second criteria and we will get this formula: