DCOUNTA
Counts nonblank cells in a database
Syntax
DCOUNTA(database, field, criteria)
Parameters
- database: Required. The range of cells that makes up the list or database
- field: Optional. Indicates which column is used in the function. If omitted, DCOUNTA counts all records that match the criteria
- criteria: Required. The range of cells that contains the conditions you specify
Example
=DCOUNTA(A1:C10, "Name", A12:A13)