For example, the pattern ?
will match strings with 3 exactly characters in these more recent functions, but not in database functions.
If you are using wildcards, test carefully.
Multi-row criteria
The criteria range for DAVERAGE 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.
