Documentation/Calc Functions/DMAX

Function name:
DMAX

Category:
Database

Summary:
DMAX calculates the maximum value across the cells (fields) of the specified column that contain numeric values, for all rows (database records) that match the specified search criteria. Blank cells or cells containing non-numeric characters are not included.

Syntax:
DMAX(Database; DatabaseField; SearchCriteria)

Returns:
Returns a real number that is the maximum of the extracted numeric values.

Returns 0 if no matches are found, or if there are no non-zero numeric values in the cells of the specified column for the matching records.

Arguments:

 * If no matches are found for the given SearchCriteria, or if there are no non-zero numeric values in the cells of the specified column for the matching records of the Database, then the function returns 0.

Examples:
The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain ">0" (this search criterion is intended to match all records in the database table).

Many more examples of both search criteria and function calls can be found in this [[Media:Calc_Database_Functions_Examples.ods | Calc spreadsheet]].

Related LibreOffice functions:
DAVERAGE

DCOUNT

DCOUNTA

DGET

DMIN

DPRODUCT

DSTDEV

DSTDEVP

DSUM

DVAR

DVARP

MAX

ODF standard:
Section 6.9.6, part 2

Equivalent Excel functions:
DMAX