Menu
EXCEL DCOUNTA FUNCTION
Excel DCOUNTA Function Introduction
The Excel Dcounta function returns the number of non-blank cells in a database field (column) for just chosen records. Records that fulfil a set of one or more user-specified criteria are included in the count. The function is extremely similar to Excel’s Dcount function, with the exception that the Dcounta function counts all non-blank cells, whereas the Dcount function only counts cells with numeric values.
Description of Excel DCOUNTA Function
Syntax :
=DCOUNTA( database, [field], criteria )
Parameters :
- The following are the 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 argument that defines the database field (column) for which you wish to return the number of non-blank cells. 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 Dcounta 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.
Step By Step Guide of DCOUNTA Function
Example :
The Dcounta 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, while cell G3 displays the Dcounta formula: The Dcounta function above finds two rows where the Gender is “Male” and the Subject is “Science.” Because both of these rows have a non-blank “Score” column, the method returns the number 2. In the above example, the Dcounta function counted cell E7, which had the phrase “awaiting” in the Score field. (If the Dcount function had been used instead of the Dcounta function, this would have been omitted from the count.)
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
