FormulaCraft

MINIFS

MINIFS finds the smallest value in a min_range where corresponding cells in criteria ranges match given conditions. It pairs naturally with MAXIFS to bracket results, such as finding the cheapest item in a specific product category.

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

Verified example

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

RegionSales
East5200
West4800
East3100
West5900

=MINIFS(B2:B5,A2:A5,"East")→3100

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 minimize and the criteria range/value pairs: =MINIFS(B2:B5,A2:A5,"East").
  2. 2Only rows where the criteria column matches "East" are considered.
  3. 3Returns the smallest B value among those matching rows.

Need a version for your data?

Try: “Find the lowest sales figure for the East region only”

Related

COUNTACOUNTBLANKMODE

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

Last reviewed: