How to use DCOUNT function on Excel

Function Count on Excel is the basic Excel function that will be used to count data on Excel. Besides, we can use conditional Count counting function with COUNTIF or DCOUNT function.

The COUNTIF function will search for cells that match the given conditions. The search data area may contain regular characters or letters. With DCOUNT, the function counts the number of cells that contain numeric data in the list, or database with given conditions. The following article will guide you how to use the DCOUNT function on Excel.

1. How to combine Sumif and Vlookup functions in Excel
2. How to automatically display names when entering code in Excel
3. How to use AVERAGEIF function in Excel

Instructions for using DCOUNT on Excel

The DCOUNT function has a function syntax of DCOUNT (database, field, criteria) .

Inside:

1. Database: The range of cells or data areas to be counted, including header rows in the data area, are required parameters.
2. Field: The field or column name used to check the count condition. If you enter the column header directly, put it in quotation marks, if you enter the number, enter the corresponding number of the column from the left.
3. Criteria: The data area contains the condition cell. You can use any range, but there must be at least one column header and one cell containing conditions under the column header box.

Note:

1. The range of conditions below the list should not be set because new information will be added at the end of the list.
2. Make sure the range of conditions does not override the list.
3. To manipulate an entire column in the list, enter a blank line below the column header in the range of conditions.

We will proceed to process the following data table, counting the number of students who meet different conditions.

How to use DCOUNT function on Excel Picture 1

1. Calculate the number of students with a score greater than or equal to 8

According to the table, the data to count belongs to the numeric data type in the Van text column. In the input box, enter the formula that is = DCOUNT (A2: E7, D2, B9: B10) and press Enter.

Inside:

1. A2: E7: The data area contains the data to be counted.
2. D2: Name the data column to check the condition.
3. B9: B10: Data area contains conditions.

It is necessary to enter the field name of the conditional data area that matches the field name in the data table.

How to use DCOUNT function on Excel Picture 2

Step 2:

After pressing Enter the result is as shown below. There will be 2 students with a score greater than or equal to 8.

How to use DCOUNT function on Excel Picture 3

2. Calculate the number of students in grade A1 with a Math score greater than or equal to 7

As required, there will be 2 conditions to find value. But the DCOUNT function only uses data type counting so we can create a condition containing the Math class and grades as shown. The condition field will contain two conditions, but the conditional column name will let the column contain numeric data.

Enter the formula as = DCOUNT (A2: E7); C2; B9: B10) and press Enter.

How to use DCOUNT function on Excel Picture 4

Step 2:

As a result, only 1 grade A1 student has a Math score greater than or equal to 7.

How to use DCOUNT function on Excel Picture 5

3. Calculating grade A1 students with a score of 3 subjects is large or equal to 5

Step 1:

We will perform counting of numerical data with multiple conditions and with conditions other than numeric data. Set the condition area as shown. Then enter the formula as = DCOUNT (A2: E7; C2; B9: E10) and press Enter.

How to use DCOUNT function on Excel Picture 6

Step 2:

The result will be only one student of A1 class with a score of 3 major subjects 5.

How to use DCOUNT function on Excel Picture 7

4. Calculate the number of A1 students taking the exam

Here there will be a condition area of ​​class A1. In the input box enter the formula as = DCOUNT (A2: E7; B2; B9: B10) and press Enter as shown.

How to use DCOUNT function on Excel Picture 8

The result will be 0 even though there are 2 A1 grade students taking the exam. This is because the DCOUNT function only counts with numeric data, so the condition of class A1 is a character type so the result of the return function is 0.

How to use DCOUNT function on Excel Picture 9

Above is how to use the DCOUNT function on Excel, the data counting function with the given conditions. For examples of finding different data and an example of a DCOUNT function that returns a result 0 above, you will know how to select the condition range exactly.

Instructions for using DCOUNT on Excel

See more:

1. How to combine 2 columns Full name in Excel does not lose content
2. How to use SUMPRODUCT function in Excel
3. How to use Vlookup function in Excel

I wish you all success!