DCOUNTA()
Syntax. DCOUNTA(database,field,criteria)
Definition. This function counts the number of cells in a column, list, or database that are not empty and match the specified conditions.
Arguments
database (required) The cell range that makes up the list or database
field (optional) Indicates which column is used in the function
criteria (required) The cell range containing the field names and the filter criteria
Background. DCOUNTA() counts nonempty cells, in contrast to DCOUNT(), which counts number values.
Example. Because your business is relatively new, you want to know how many invoices were sent to companies within the United States. You also want to know the total number of invoices in the database so that you can calculate the percentage ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
