FormulaCraft

MAXIFS

MAXIFS finds the largest value in a max_range where corresponding cells in one or more criteria ranges satisfy given conditions. It is the conditional counterpart to MAX, useful for finding the best result within a specific category or time period.

Excel
=MAXIFS(B2:B5,A2:A5,"East")
Google Sheets
=MAXIFS(B2:B5,A2:A5,"East")
✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

RegionSales
East5200
West4800
East6100
West5900

=MAXIFS(B2:B5,A2:A5,"East")→6100

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1Specify the range to maximize and the criteria range/value pairs: =MAXIFS(B2:B5,A2:A5,"East").
  2. 2MAXIFS evaluates each row; only rows where A equals "East" are considered.
  3. 3Returns the largest B value among the matching rows.

Need a version for your data?

Try: “Find the highest sales number only for the East region”

Related

COUNTACOUNTBLANKMODE

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: