Step 1 – First, we will create a new table with a category name to display the result, as shown below. Now we will apply the Excel MAX IF function to find out the maximum sales value by following the below steps. In such a case, we can combine MAX and If Function with an array formula so that it makes the task very easier to find out the largest sales value category wise in Excel.Ĭonsider the below example, which has Product Name, Category and Sales value which is shown below. Using only the max function, we can check only the maximum value, but we cannot check the maximum value category wise if the sales data contain a huge category and sales value. Assume that we need to check the largest sales value category wise.
In this example, we will learn how to use MAX IF function in Excel. In the below result, the Max function will check for the largest number in the D column and return the maximum sales value as 1250.Įxample #2 – Using MAX IF Function in Excel with an array formula
Step 3 – Press enter so that we will get the MAX value is 1250, which is shown in the below screenshot. Step 1 – First, select the new cell, i.e. Let’s understand the working of the MAX IF Function in Excel with some example. MAX and IF Functions in Excel is very simple and easy to use.