Next, we want to find the rows where the product name matches the product in C11: The formula starts with the MIN and IF functions, and their opening brackets: NOTE: You can also calculate MIN IF and MAX IF with Multiple Criteria MIN IF Formula To make it easy to select a product, I created a drop down list of product names, by using data validation. I’ve selected a product in cell C11, and the formula will be built in cell D11. So, we’ll have to create our own MINIF formula, using MIN and IF. There is a SUMIF function and a COUNTIF function, but no MINIF or MAXIF. In this example, we want to see the MIN and MAX for a specific product.
Now you’re ready for advanced calculations, like how to find MIN IF or MAX IF in Excel. When you were first learning how to use Excel, you quickly discovered the basic Excel functions, like SUM, COUNT, MIN, MAX, and AVERAGE.
