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.

Excel DCOUNT function

Multi-row criteria

The criteria range for DMIN 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.

Excel DCOUNTA function

Use the DMIN function to get the minimum value.

Excel DMAX function