Excel DMAX Function Tutorial

Excel has a specific group of functions - the database functions - that are designed specifically to work with an Excel database.

For the most part, these functions are variations of commonly used Excel functions such as SUM, AVERAGE, MAX, and MIN.

The main difference between a regular function and its database counterpart - such as MAX and DMAX - is that DMAX lets you specify one or more criteria which act as data filters .

Only those records that match the set criteria are included in the calculations performed by the database function.

Once the data has been filtered, the MAX part of DMAX will return the largest or maximum value in a specific column of data.

To find out all the details, read this tutorial on the Excel DMAX function.

Related Tutorials

• Excel DSUM Function
• Excel DCOUNT Function
• Excel DAVERAGE Function