<div class="raw-html-embed">    <p>The <b>MAXIFS</b> function is one of the <a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#statistical" onclick="onhyperlinkclick(this)">statistical functions</a>. It is used to return the maximum value among cells specified by a given set of conditions or criteria.</p>

    <h5 class="pt8">Syntax</h5>
    <p><b><em>MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)</em></b></p>
    <p>The <b>MAXIFS</b> function has the following arguments:</p>
    <table style="width: 40%">
        <tbody>
            <tr>
                <th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
                <th style="background-color: #f4f4f4"><b>Description</b></th>
            </tr>
            <tr>
                <td><b><em>max_range</em></b></td>
                <td>The range of cells in which the maximum will be determined.</td>
            </tr>
            <tr>
                <td><b><em>criteria_range1</em></b></td>
                <td>The first selected range of cells to apply the <em>criteria1</em> to.</td>
            </tr>
            <tr>
                <td><b><em>criteria1</em></b></td>
                <td>The first condition that must be met. It is applied to the <em>criteria_range1</em> and used to determine which cells in the <em>max_range</em> will be evaluated as maximum.</td>
            </tr>
            <tr>
                <td><b><em>criteria_range2, criteria2</em></b></td>
                <td>Additional ranges of cells and their corresponding criteria. These arguments are optional.</td>
            </tr>
        </tbody>
    </table>

    <h5 class="pt8">Notes</h5>
    <p>You can use wildcard characters when specifying criteria. The question mark "?" can replace any single character and the asterisk "*" can be used instead of any number of characters.</p>
    <p><a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#howtoapplyfunctions_block" onclick="onhyperlinkclick(this)">How to apply</a> the <b>MAXIFS</b> function.</p>

    <h5 class="pt8">Examples</h5>
    <p>The figure below displays the result returned by the <b>MAXIFS</b> function.</p>
    <p><img alt="MAXIFS Function" src="https://static-helpcenter.teamlab.info/maxifs_f572b47332.png"></p></div>

MAXIFS Function

Docs

Argument	Description
*max_range*	The range of cells in which the maximum will be determined.
*criteria_range1*	The first selected range of cells to apply the criteria1 to.
*criteria1*	The first condition that must be met. It is applied to the criteria_range1 and used to determine which cells in the max_range will be evaluated as maximum.
*criteria_range2, criteria2*	Additional ranges of cells and their corresponding criteria. These arguments are optional.

MAXIFS Function

Syntax

Notes

Examples

Host ONLYOFFICE Docs on your own server or use it in the cloud