Skip to Content

DMIN

Returns the minimum value from selected database entries

Syntax

DMIN(database, field, criteria)

Parameters

  • database: Required. The range of cells that makes up the list or database
  • field: Required. Indicates which column is used in the function
  • criteria: Required. The range of cells that contains the conditions you specify

Example

=DMIN(A1:C10, "Profit", A12:A13)
Returns: NumberSince: Excel 2003