Microsoft Excel

Learn How to Get Maximum if Multiple Criteria in Microsoft Excel

Learn How to Get the Maximum if Multiple Criteria in Microsoft Excel

The main purpose of this formula is to get the maximum value in a data set based on more than one criteria. Here we will learn how to get the maximum value with multiple matching the multiple criteria in the given data range in the workbook in Microsoft Excel.

That implies, with the help of a formula based on the MAX and IF functions, you can able to get the maximum value in a data set based on more than one criteria.

So, with the help of this formula, you can able to get the maximum value with multiple matching the multiple criteria in the given data range in the workbook in Microsoft Excel.

 

General Formula to Get Maximum if Multiple Criteria 

{=MAX(IF(rng1=criteria1,IF(rng2=criteria2,values)))}

 

The Explanation to Get Maximum if Multiple Criteria

Learn How to Get Maximum if Multiple Criteria in Microsoft Excel

So we know that with the help of the given formula above, you can able to get the maximum value in a data set based on more than one criteria.

Here we will learn how to get the maximum value with multiple matching the multiple criteria in the given data range in the workbook in Microsoft Excel. As we know that this formula uses two nested IF functions wrapped inside the MAX function.

Which is used to return the maximum price with two criteria. Starting with a logical test of the first IF statement, as given in the example shown above.

So now you have learned how to get the maximum value with multiple matching the multiple criteria in the given data range in the workbook in Microsoft Excel.