Professor Excel
minif, maxif, minifs, maxifs, formula, excel

MINIF & MAXIF: 5 Ways to Get a Conditional Minimum Value

Until Excel 2016, there is no built-in MINIF-Formula in Excel. There are COUNTIF, SUMIF, AVERAGEIF but no MINIF nor MAXIF before the latest version. However, there are situations in which you need to get the minimum under a condition. In the following post, we are going to illustrate how to return the minimum using a simple example. We got an Excel table with two columns “Car type” and “Price”. We want to know the minimum price for each car type. Sounds easy? Unfortunately, Excel makes it unnecessarily difficult to calculate.
[…]