For example, the pattern ?
will match strings that contain exactly 3 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 DVARP 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.
If data represents the entire population, use the DVARP function.
If data represents the entire population, use the DSTDEVP function.
