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.
;
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)
Pressing Enter results:
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.
Pressing Enter results:
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:
Pressing Enter results:
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)
Pressing Enter results:
You should read it
- OR function in Excel, how to use the OR function, and examples
- INDIRECT function in Excel - How to use INDIRECT function and examples using INDIRECT function
- VLOOKUP function to use and specific examples
- IRR function in Excel - Usage and examples
- Offset function in Excel - Usage and examples
- The MID function in Excel, how to use the MID function, and examples
- How to use the SUMIF function in Excel
- DSUM function in Excel, how to use DSUM function and examples
May be interested
- Functions rounded up, how to round up in Excelfunctions rounded up, how to round up in excel. you are looking for rounding up functions to round numbers up in excel. so, please refer to the following article to know how to round up using functions in excel.
- INDIRECT function in Excel - How to use INDIRECT function and examples using INDIRECT functionindirect function in excel - how to use indirect function and examples using indirect function. you want to refer to a range of data without changing the formula in the cell. the following article introduces you to the indirect function in excel to help you reference
- Random function in Excel (RAND function), how to use the Random function and examplesrandom function in excel (rand function), how to use the random function and examples. you need to get a random value in a range of values. to avoid duplicate values and objectivity, you should use the rand () function. the article below gi
- Comparison functions in Excel - How to use comparison functions and examples using comparison functionscomparison functions in excel - how to use comparison functions and examples using comparison functions with a large amount of data, you want to check for duplicates by checking normally, it is really hard. in this article, introduce to you the functions
- How to align in Word - Instructions on how to align in Word 2007, 2010, 2013, 2016how to align in word - instructions on how to align in word 2007, 2010, 2013, 2016. for each document there are general provisions on how and how to present text. the ministry of the interior has issued a circular on guidelines on techniques and techniques for presenting administrative documents no.
- Delete pages in Word - Instructions on how to delete pages in Worddelete pages in word - instructions on how to delete pages in word. you copy the document file on a web page, there are some extra pages you need to delete, or simply copying from the web will have some white pages exist in your data file.