The values to sum are extracted from a given field in the database, specified as an argument.
Field can be specified with a name or index.
For example, the pattern ?
will match strings with 3 exactly characters in more modern functions, but not in the database functions.
If you are using wildcards, test carefully.
Multi-row criteria
The criteria range for DSUM can include more than one row below the headers.
When a field is provided DCOUNT will only count numeric values in the field.
UseDCOUNTAto count numbers or text values in a given field.
Use the MAX function to get the maximum value.
Use the DMIN function to get the minimum value.
The values to multiply are extracted from a given field in the database, specified as an argument.
