Excel Function Translator Logo
    The Excel Translator

    MAXIFS

    Statistical

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

    Translations
    EnglishMAXIFS
    FrenchMAX.SI.ENS
    SpanishMAX.SI.CONJUNTO
    GermanMAXWENNS
    ItalianMAX.PIÙ.SE
    PortugueseMÁXIMOSES
    DutchMAX.ALS.VOORWAARDEN
    PolishMAKS.WARUNKI
    RussianМАКСЕСЛИ
    TurkishMAKSEĞERLERİ
    CzechMAXIM.KDYŽ.VÍCE
    HungarianMAX.HA.TÖBB
    SwedishMAXOM
    DanishMAKS.HVISER
    FinnishMAKS.JOS.JOUKKO
    Syntax
    MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

    Arguments

    • max_rangeRange to find maximum
    • criteria_range1Range to evaluate
    • criteria1Condition to meet
    • criteria_range2Additional range(optional)
    • criteria2Additional condition(optional)
    Examples
    =MAXIFS(B:B,A:A,"Sales")
    Highest sale

    Max for Sales department

    =MAXIFS(Scores,Team,"A",Year,2024)
    Best score

    Max with multiple criteria

    =MAXIFS(C:C,A:A,">="&D1)
    Max above threshold

    Conditional maximum

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

    In what order do the arguments go in MAXIFS?

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

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

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

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

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

    Need to translate a formula using MAXIFS?

    Use our translator to convert your complete formula