Manuals/calci/DMAX

DMAX(database, field, criteria)

• Where 'database' is the range of cells that makes up the list or database

• 'field' shows which column is used in the function and

• 'criteria' is the range of cells that contains the specified condition.

DMAX()displays the largest number in a column of a list or database that matches the specified criteria.

Description

DMAX(database, field, criteria)

• Criteria can be any range on the Calci with minimum of one column and at least one row indicating the condition.
• The Criteria columns should not overlap the list of data.

Examples

Name	Age	Salary	Age
	<40	>5000	>32
	>30
Name	Age	Salary
John	34	5500
Bill	35	6500
Clark	29	7000
Bob	45	9000
Susan	37	4000
Jill	45	8000

=DMAX() :

=DMAX() :

=DMAX() :

See Also

• DMIN

References

• List of Aggregate Functions
• DMAX