How to Find MIN IF and MAX IF in Excel

In this video, you'll see how to find the highest and lowest values for specific products, in a long sales list, with multiple products.


With a simple MIN formula you can find the lowest value in a range of cells. With MAX, you can find the highest value.

If you want to add criteria to the MIN or MAX, you can combine those function with IF, to get the correct results.


Download the sample file from my Contextures, and see written steps:
http://www.contextures.com/exc....elminmaxfunction.htm