Unlike DCOUNT, which counts only numeric values, DCOUNTA countsbothnumeric and text values.
Empty cells are ignored.
UseDCOUNTto count only numeric values.
Note: The DCOUNTA function will count numbers or text in a given field, whereasDCOUNTonly counts numeric values.
Criteria options
The criteria can include a variety of expressions.
The table below shows some examples:
Thecriteriarange for DCOUNT 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.
The values to sum are extracted from a given field in the database.
The values to multiply are extracted from a given field in the database, specified as an argument.
