SheetFX
≡
<< Go back to all functions

DMIN

The DMIN function in Google Sheets is used to return the minimum value selected from a database table-like array or range using a SQL-like query. This function is particularly useful when dealing with large amounts of data and needing to filter and extract specific information.

Function Syntax and Parameters

Syntax: DMIN(database, field, criteria)

Parameters:

  • database: The range or array representing the database table.
  • field: The column or range representing the field to apply the criteria.
  • criteria: The criteria or expression to be met for the selection.

Step-by-Step Tutorial

  1. Using DMIN with a database range:
    • Example: =DMIN(A1:D10, "Salary", G1:G2)
    • Result: Returns the minimum salary from the specified database range that meets the given criteria specified in cell G1 and G2.

Use Cases and Scenarios

  1. Sales Analysis: Determine the minimum sales figure based on specific criteria.
  2. Financial Data: Extract the lowest expense value based on certain conditions.
  3. Inventory Management: Find the minimum quantity available for a particular item in stock.

Related Function

  • MIN: Extract the smallest value from a given set.
  • DMAX: Returns the maximum value selected from a database table-like array or range using a SQL-like query.
  • DAVERAGE: Calculates the average of selected database entries based on specified criteria.

Related Article