Skip to Content

DCOUNT

Counts the cells that contain numbers in a database

Syntax

DCOUNT(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, DCOUNT counts all records that match the criteria
  • criteria: Required. The range of cells that contains the conditions you specify

Example

=DCOUNT(A1:C10, "Age", A12:A13)
Returns: NumberSince: Excel 2003