Menu
EXCEL DECOUNT FUNCTION
Excel DCOUNT Function Introduction
The Excel Dcount function returns the number of cells in a database field (column) that have numeric values for just chosen records. Records that fulfil a set of one or more user-specified criteria are included in the count.
Description of Excel DCOUNT Function
Syntax :
=DCOUNT(database, [field], criterion)
Parameters :
- The following arguments:
Database :
- A set of cells that contains the database. The field names should be specified in the database’s top row.
Field :
- An optional parameter that defines the database field (column) for which you wish to retrieve the count. This can be a field number or the field name (i.e. the header in the top row of the database) surrounded by quotations (e.g. “Gender”, “Subject”, etc). If the [field] parameter is not specified, the Dcount function simply returns the number of records that meet the specified criteria.
Criterion :
A range of cells containing the criteria for determining which records should be counted. The range can comprise one or more criteria, which are displayed in one cell as a field name and the condition for that field in the cell below.
E.g. :
| Subject | Age |
| Math | >8 |
Step By Step Guide of DCOUNT Function
Example :
The Dcount function is used in the following example to count the number of Science test results obtained for male students. Cells G1 – H2 specify the conditions, and cell G3 displays the Dcount formula: The Dcount method above discovers two rows where the Gender is “Male” and the Subject is “Science.” Only one of these rows (row 13), however, has a number in the “Score” column. As a result, thfunction returns the value 1. In the above example, the Dcountfunction has omitted cell E7 from the count since it includes text rather than a number. (However, if the Dcounta function had been used instead of the Dcount function, this cell would have been counted.)
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
