Counts the number of non-empty cells in a database column that match specified conditions.
ไวยากรณ์
DCOUNTA(database, field, criteria)อาร์กิวเมนต์
databaseจำเป็น
The range of cells that makes up the list or database.
fieldจำเป็น
The column label or index used in the function.
criteriaจำเป็น
The range of cells that contains the specified conditions.
DCOUNTA counts cells that are not empty in the specified field of records that match the criteria. It is particularly useful for analyzing large datasets where you need to filter by multiple conditions before counting.
=DCOUNTA(A1:C10, "Sales", E1:F2)→5Counts the number of non-empty 'Sales' entries in the database that meet the criteria defined in E1:F2.
Prepare your database
Ensure your data is organized in a table format with headers in the first row.
Define criteria
Create a separate range containing the column headers and the specific criteria you want to filter by.
Apply the function
Enter the DCOUNTA formula referencing your database, the target field, and your criteria range.
DCOUNT counts only numeric cells, while DCOUNTA counts any non-empty cell, including text.