When more than one record matches criteria, DGET will throw the #NUM error.
Criteria options
The criteria can include a variety of expressions, including somewildcards.
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 DGET 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 DMIN function to get the minimum value.
Use the MAX function to get the maximum value.
