DCOUNT function in excel
Excel DCOUNT Function
Summary. The Excel DCOUNT function counts matching records in a database using criteria and an optional field. ...
Count matching records in a database.
Numeric count of matching records.
=DCOUNT (database, [field], criteria)
database - Database range including headers. field - [optional] Field name or index to count.