DMIN Function in Google Sheets

Find the minimum value in a database that meets specified criteria using the DMIN function.

DMIN Function

The DMIN function in Google Sheets finds the minimum value in a specified field of a database that meets given criteria.

Syntax

DMIN(database, field, criteria)
  • database: The range of cells that make up the database.
  • field: The column number or header name containing the values to evaluate.
  • criteria: The range of cells that contain the conditions for finding the minimum value.

Examples

  1. Basic Example

Find the minimum value in field 3 of the database A1:C10 where criteria are in E1:E2:

=DMIN(A1:C10, 3, E1:E2)
  1. Using Header Names

Find the minimum value in the ‘Quantity’ column where criteria are in G1:G2:

=DMIN(A1:C10, "Quantity", G1:G2)

Notes

  • Useful for identifying the lowest value in a subset of data.
  • DMAX: Find the maximum value in a database meeting specified criteria.
  • DAVERAGE: Calculate the average of values meeting criteria.