For those who are familiar with DSUM, no need to spend extra time to learn the use of DCOUNT, DCOUNTA functions in Google Sheets. All these are Database Functions and the criteria use are same.
Earlier I’ve published a complete tutorial covering all count formulas in Google Sheets. In that list also you can see some advanced tips related to Dcount and Dcounta.
The purpose of DCOUNT, DCOUNTA functions in Google Sheets are to conditional count column ranges but they are little different. Google Sheets Dcount function is to count numeric values from a selected database or range using an SQL-like query. But the use of Dcounta function is to count numeric as well as text values. So you can consider this post as an answer to your following queries.
- Google Sheets DCOUNT Function and Formula usage – How to?
- Google Sheets DCOUNTA Function and Formula usage – How to?
So here we go.
How to Use Dcount, Dcounta Functions in Google Sheets
DCOUNT(database, field, criteria)
DCOUNTA(database, field, criteria)
Sample Data and Formula to Explain the Syntaxes :
In the above example, I’ve clearly marked the Syntax elements. But I haven’t marked only one thing, i.e., the field number 4. Field number means the column number in the data base.
The above DCOUNTA formula counts column D if Column D value is “Absent” and Column C value is “Planning”. Here I’ve used DCOUNTA function since the column D value is in Text format. If it’s numeric, you should use DCOUNT.
With the above formula, I could easily find the number of persons absent from Planning Division.
This’s just a basic example to the use of Dcounta in Google Sheets. You can use comparison operators in the criteria field. Also, you should know how to use date as criteria in Dcount as well as Dcounta. I’ve already posted the same for DSUM. Since the criteria use is exactly the same for Dcount as well as Dcounta, I’m just pointing you to the relevant tutorials below. Further you can check my eBook as well as paperback guide which has lots of custom formulas for the functions DSUM, SUMPRODUCT, SUMIF, SUMIFS and QUERY.
As I’ve told above, the above reference guide is applicable to Dcount, Dcounta Functions in Google Sheets. That’s all for now. Enjoy!