SheetFX
≡
<< Go back to all functions

DMAX

The DMAX function in Google Sheets is a powerful tool to return the maximum value selected from a database table-like array or range using a SQL-like query. Whether you're analyzing data, performing calculations, or extracting specific information, the DMAX function simplifies the task. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: DMAX(database, field, criteria)

Parameters:

  • database: The range of cells that makes up the database table.
  • field: The column or field containing the values to consider.
  • criteria: The range of cells that specifies the conditions to meet.

Step-by-Step Tutorial

  1. Using DMAX to find the maximum value:
    • Example: =DMAX(A1:C10, "Sales", A15:C20)
    • Result: Returns the maximum value from the "Sales" column in the database table A1:C10, where the criteria in A15:C20 are met.

Use Cases and Scenarios

  1. Sales Analysis: Find the highest sales figure based on specific conditions.
  2. Data Filtering: Extract the maximum value of a particular field based on specific criteria.
  3. Statistical Analysis: Calculate the maximum value from a set of data meeting certain conditions.

Related Functions

  • DMIN: Returns the minimum 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 Articles