Excel Function Translator Logo
    The Excel Translator

    MINIFS

    Statistical

    Returns the minimum value among cells that meet one or more criteria.

    Translations
    EnglishMINIFS
    FrenchMIN.SI.ENS
    SpanishMIN.SI.CONJUNTO
    GermanMINWENNS
    ItalianMIN.PIÙ.SE
    PortugueseMÍNIMOSES
    DutchMIN.ALS.VOORWAARDEN
    PolishMIN.WARUNKI
    RussianМИНЕСЛИ
    TurkishMİNEĞERLERİ
    CzechMINIM.KDYŽ.VÍCE
    HungarianMIN.HA.TÖBB
    SwedishMINOM
    DanishMIN.HVISER
    FinnishMIN.JOS.JOUKKO
    Syntax
    MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

    Arguments

    • min_rangeRange to find minimum
    • criteria_range1Range to evaluate
    • criteria1Condition to meet
    • criteria_range2Additional range(optional)
    • criteria2Additional condition(optional)
    Examples
    =MINIFS(B:B,A:A,"Sales")
    Lowest sale

    Min for Sales department

    =MINIFS(Prices,Category,"Electronics")
    Cheapest

    Cheapest in category

    =MINIFS(C:C,A:A,">0")
    Min positive

    Smallest positive value

    Tips & Best Practices
    • •Available in Excel 2019 and later
    • •Returns 0 if no matches found
    • •Pair with MAXIFS for range analysis
    Common Mistakes
    • •Putting min_range in the wrong argument position - like the other *IFS functions, MINIFS requires min_range first, before any of the criteria pairs
    • •Supplying criteria ranges with different dimensions than min_range, which raises a #VALUE! error since every range in the formula must match in size
    • •Assuming MINIFS supports an OR relationship between multiple criteria - like the other *IFS functions, it always requires ALL conditions to be true simultaneously
    Related Functions
    MAXIFSFinds the largest matching value using the identical multi-criteria structure as MINIFS.
    MINFinds the smallest value across an entire range without any conditional filtering.
    SUMIFSSums matching values instead of finding the smallest, using the same argument order and criteria structure.
    Frequently Asked Questions

    In what order do the arguments go in MINIFS?

    min_range comes first, followed by pairs of criteria_range and criteria - the same order used by MAXIFS and SUMIFS.

    Can MINIFS match ANY of several conditions instead of ALL of them?

    Not directly - like the other *IFS functions, MINIFS always applies AND logic across every criteria pair you supply.

    Why do I get a #VALUE! error with MINIFS?

    One of your criteria ranges likely has different dimensions than min_range - every range in the formula must cover the same number of rows and columns.

    Need to translate a formula using MINIFS?

    Use our translator to convert your complete formula