29Sep2014

DMIN and DMAX

DMIN and DMAX functions fall under Database functions in Microsoft Excel. These Excel functions are used to find specific information based on given criteria.

DMIN:

The DMIN function in Microsoft Excel returns the smallest number in a column of records in a list or database that matches conditions you specify.

Syntax for this Excel function is as followed: DMIN(database, field, criteria)

DMIN excel example

In the above example there is a table with the columns: Region, Sales Person and Sales (A5 to C12). We need to create a criteria table (A1 to C2). Based on the criteria table values, the formula in cell E2 will show various results. As we have entered ‘West’(cell A2) in the criteria table the formula in E2 will show the minimum sales in the West region (which is 32).

Similarly, if we give the criteria as Paul in B2 the total sales of Paul in all regions will be shown as output.

DMIN excel example 2

 

DMAX:

The DMAX function in Microsoft Excel returns the largest number in a column of records in a list or database that matches conditions you specify.

Syntax:

Syntax for this Excel function is as followed: DMAX(database, field, criteria)

DMAX Excel example

In the above Excel example there is a table where we mentioned the database of Region, Sales person and Sales from A5 to C12 and we mentioned the criteria in table from A1 to C2 based on the criteria input the output (E2) will vary. As we mentioned East in the Region of the criteria table (A2) the largest number is shown as 230 in output.

Similarly, if we give the criteria as Raj in B2 the total sales of Raj in all regions will be shown as output. Here in the Excel example Raj made total sales of 230.

DMAX Excel example 2.jpg

  • 29 Sep, 2014
  • Excel for Commerce
  • 0 Comments
  • dmax, dmin,

Categories

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *