The syntax of ‘MINFS’ and MAXIFS’
‘MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)’
1: Our first parameter is ‘min_range’ which is simply the range from which we are seeking a minimum value. Clearly, this parameter is required.
2: Second, we have ‘criteria_range1’ which is the range of cells that we will impose our criteria (filter, if you will). This can be the same as the ‘min_range’ or it can be another range. However, one thing to note is that ‘criteria_range1’ must be the same size and shape as the ‘min_range’. This parameter is also required.
3: The third parameter of the ‘MINIFS’ function is the required ‘criteria1’ which is the criteria that we want to impose upon the ‘criteria_range’. This parameter can be a number, an expression or text that tells the function which cells within our ‘min_range’ to evaluate.
Please notice, that all of these parameters also apply to ‘MAXIFS’.
We could stop there since those are the only required parameters.
But just like with ‘criteria_range1’, further ‘criteria_range’ selections must be the same shape and size as the ‘min_range’ (or ‘max_range’) in order for the function to work properly. Otherwise, it will return the ‘#VALUE’ error.