FormulaCraft

DMIN

DMIN finds the smallest numeric value in a database column among all rows that satisfy the criteria range, functioning as a conditional MIN with multi-column filtering support. Use it to quickly surface the lowest value in a filtered dataset.

Excel
=DMIN(A1:C5,"Revenue",E1:E2)
Google Sheets
=DMIN(A1:C5,"Revenue",E1:E2)

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. 1Build your database range with a header row and set up a criteria range with the filter conditions.
  2. 2Enter =DMIN(database, field, criteria) to return the minimum in the specified field.
  3. 3Pair with DMAX over the same criteria to compute the range for the filtered subset.

Need a version for your data?

Try: “What is the lowest revenue among West region orders?”

Related

DSUMDAVERAGEDCOUNT

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

Last reviewed: