Functions
DMAX
Maximum field value for rows matching criteria
Try it
When to use it
When should I use DMAX?
Use DMAX to find the highest value in a field among only the rows that match your criteria — useful for finding the top score, highest sale, or maximum reading within a filtered subset of a database table.
Used in
Syntax
DMAX(database, field, criteria)Examples
=DMAX({"Name","Score";"Alice",90;"Bob",80;"Carol",70},"Score",{"Score";">75"}) // => 90
=DMAX({"Cat","Val";"A",10;"A",30;"B",20},2,{"Cat";"A"}) // => 30
=DMAX({"G","V";"X",5;"X",15;"X",10},2,{"G";"X"}) // => 15