Criteria options

The criteria can include a variety of expressions.

Use the DMIN function to get the minimum value.

Use the MAX function to get the maximum value.

Excel DCOUNTA function

The values to sum are extracted from a given field in the database.

The values to multiply are extracted from a given field in the database, specified as an argument.

Excel DMAX function

Excel DMIN function

Excel DSUM function

Excel DPRODUCT function