DCount function in Excel - How to use the DCount function and examples using the DCount function

You have a large list of students who want to get a high total score, but don't want to spend a lot of time. In this article, introduce to you the DCount Function in Excel. Help you use the DCount function and include examples from which you can address your request.

DCount function in Excel - How to use the DCount function and examples using the DCount function Picture 1 ;

Describe the DCount function

The Dcount function counts the number of values ​​(numeric data) of field or column names in a data range with the specified conditions described in the condition area.

DCount function syntax

DCOUNT (database, field, criteria)

Inside:

- Database: Range of cells or container of data to be counted, including the header row in the data area, is a required parameter.

- Field: The field or column name is used to check counting conditions, there are 2 ways to enter data fields:

+ Method 1: Enter the field name of the data column directly, paying attention to the right column name in quotation marks.

+ Method 2: Enter the corresponding ordinal number of that column from the left.

- Criteria: The condition data area used to count quantities, which is a mandatory parameter.

Note Dcount

- The condition area (criteria criteria) must contain the field name.

- Conditional data area should not be placed below the list because if the list below is not empty you cannot add information.

- Make sure the condition area does not coincide with the main data range.

Example of using the DCount function

Give a table of results of students taking the entrance exam. Request:

- Count the total number of office class students participating in the exam

- Count the total number of students with math scores greater than or equal to 8

- Count the total number of office class students with a math score greater than or equal to 8 (counting with multiple conditions containing non-numeric data)

- Count the total number of students in the office class with math scores, chemistry points, and physics scores equal to or greater than 8.

Tutorial:

1. Count the total number of office class students participating in the exam:

Counting the total number of office class students participating in the test => condition area Class = VP. In the cell to count enter the formula: = DCOUNT (C4: I13, F4, C15: C16)

DCount function in Excel - How to use the DCount function and examples using the DCount function Picture 2

Pressing Enter results:

DCount function in Excel - How to use the DCount function and examples using the DCount function Picture 3

As you can see, there are 3 office students taking the exam but the result is zero. Because the Dcount function only counts with numeric data, the class condition = VP is a character type so the function returns a value of 0. So With this condition you use another function to count.

So through the first requirement you need to know that the Dcount function only uses counting with data of numeric data types.

2. Count the total number of students with math scores greater than or equal to 8

The data to be counted is a numeric data type in the Math score column. In the box to calculate the students with math scores greater than or equal to 8 enter the formula:

= DCOUNT (C4: I13, G4, D15: D16)

With:

- C4: I13: A data area containing data to be counted.

- G4: Name of data column to check condition.

- D15: D16: Data area contains conditions.

You should note that the field name of the conditional data area must match the field name in the source data table.

DCount function in Excel - How to use the DCount function and examples using the DCount function Picture 4

Pressing Enter results:

DCount function in Excel - How to use the DCount function and examples using the DCount function Picture 5

3. Count the total number of office class students with math scores greater than or equal to 8

Here, the count condition contains two conditions, but the Dcount function only uses counting numeric data types. You can do the following. To ensure that the condition is not numeric data in the range, the field name is used to check the condition of the column name containing numeric data. Create the data area containing Grade and Math Score as shown. In a cell that needs to calculate enter the formula: = DCOUNT (C4: I13, G4, C15: D16)

Thus, the condition area contains two conditions, but the column name contains the condition that you only need the column to contain numeric data:

DCount function in Excel - How to use the DCount function and examples using the DCount function Picture 6

Pressing Enter results:

DCount function in Excel - How to use the DCount function and examples using the DCount function Picture 7

4. Count the total number of students in the office class with math scores, chemistry points, and physics scores equal to or greater than 8

With this requirement, performing numerical data counting is conditional and comes with conditions that are not numeric data.

Set the condition area as shown. In the cell to calculate enter the formula: = DCOUNT (C4: I13, G4, C15: F16)

DCount function in Excel - How to use the DCount function and examples using the DCount function Picture 8

Pressing Enter  results:

DCount function in Excel - How to use the DCount function and examples using the DCount function Picture 9