Excel Function: MINIFS

Use MINIFS to return the minimum value among cells specified by a given set of conditions or criteria

EXAMPLE:

NOTES:

• min_range is the cells in which the minimum will be determined
• criteria_range1 is the set of cells to evaluate
• criteria1 is the number, expression or text that defines which cells will be evaluated
• Additional ranges and associated criteria can be used up to 126 pairs

---