DCOUNTA
Formulas / DCOUNTACount matching records in a database using criteria and an optional field.
DCOUNTA(database, field, criteria)
- database - range of cells that include field headers
- field - name or index of the field to which to count
- criteria - range of cells with the same headers as in the database
Examples
DCOUNTA(B7:E14,"Color",B4:E5)The DCOUNTA function can be used to count the number of records in a database that meet certain criteria. For example this formula returns a count of how many records in the database have a color of "red" and a price greater than 10.
DCOUNTA(B7:E14,1,B4:E5)The DCOUNTA function can be used with a numerical argument instead of a string argument. For example, this formula also returns a count of how many records in the database have a color of "red" and a price greater than 10.
DCOUNTA(B7:E14,,B4:E5)The DCOUNTA function can also be used without any argument in the second argument position. For example, this formula also returns a count of how many records in the database have a color of "red" and a price greater than 10.
Summary
DCOUNTA is a function used to count values in a database that meet the criteria specified. It requires a database and criteria argument, while the field argument is optional.
- The DCOUNTA function returns a numeric count of matching records, including both numeric and text values, and ignores empty cells.
Need help with Formulas?
Frequently Asked Questions
What is the DCOUNTA Function?
What are the Arguments of the DCOUNTA Function?
What is the Database Argument for the DCOUNTA Function?
What is the Field Argument for the DCOUNTA Function?
What is the Criteria Argument for the DCOUNTA Function?
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.