Formulas > =MINIFS()
How to Use MINIFS() in Google Sheets
Description
How To Actually Use MINIFS() in Sheets
MINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)
Try MINIFS yourself
Use the MINIFS formula to find the minimum value in the range B2:B10 where the corresponding values in A2:A10 are greater than 10.
Hints (2)
-
Remember to specify the range for the values you want to find the minimum of.
-
You'll need to set a criteria range and define the condition for filtering.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the MINIFS() formula:
Generate a MINIFS() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses MINIFS(). 2 free AI generations, no signup. Members get unlimited use.
Generate a MINIFS() formula