Counts the number of non-empty cells in a database column that match specified conditions.
ฟังก์ชันนี้ทำงานใน Google Sheets เหมือนกับใน Excel — ไวยากรณ์และอาร์กิวเมนต์เดียวกัน
DCOUNTA(database, field, criteria)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)ผลลัพธ์: 5
Counts the number of non-empty 'Sales' entries in the database that meet the criteria defined in E1:F2.
DCOUNT counts only numeric cells, while DCOUNTA counts any non-empty cell, including text.