How to Use DMAX() in Google Sheets

Description

Returns the maximum value selected from a database table-like array or range using a SQL-like query.

How To Actually Use DMAX() in Sheets

DMAX(database, field, criteria)

Try DMAX yourself

Use the DMAX function to find the maximum value in the range B2:B10 where the criteria in A2:A10 is 'Sales'. The result should be displayed in cell D1.

Your formula

Hints (3)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for DMAX(). Click through to watch.

Watch more tutorials

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

Ultimate Checklist in Google Sheets

how to create and customize checklists using Google Sheets. I show you h...

Beginner

COUNTA() COUNTIF() IF() SPARKLINE()

Learn Google Sheet Formulas The Hard Way

One weird way to learn more about what Google Sheets can do. https://bet...

Unlock these tutorials

Learn more about the DMAX() formula:

Generate a DMAX() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses DMAX(). 2 free AI generations, no signup. Members get unlimited use.

Generate a DMAX() formula

How to Use DMAX() in Google Sheets

Try DMAX yourself

More related tutorials

Write Apps Script to Create a New Google Sheets Formula

Ultimate Checklist in Google Sheets

Learn Google Sheet Formulas The Hard Way