The DMIN function with example in Excel

 The DMIN function in Excel is used to find the minimum value in a given range based on specified criteria. Let me break it down for you:

1. Syntax:

   DMIN(database, field, criteria)
   

   • database: The range of cells that contains your data.
   • field: The column or field within the database that you want to evaluate.
   • criteria: The range of cells that specifies the conditions for selecting the data (usually includes column headers and criteria).

2. Example: Let’s say we have the following data:

   Table

   Product	Sales
   A	100
   B	150
   C	80
   D	120

   To find the minimum sales value for products with sales greater than 90, you can use the DMIN function as follows:

   =DMIN(A1:B5, "Sales", A7:B8)
   

   Here:

   • A1:B5 is the data range.
   • "Sales" is the field/column name.
   • A7:B8 contains the criteria (in this case, “Sales” > 90).

   The result will be the minimum sales value for products meeting the specified criteria.

Remember to adjust the cell references according to your actual data range and criteria.