Excel Function : DCOUNT

Download now!

Excel Function : DCOUNT

Category

Database

Description

Counts the cells that contain numbers in a database

Microsoft Excel Reference Page

https://support.office.com/en-us/article/DCOUNT-function-c1fc7b93-fb0d-4d8d-97db-8d5f076eaeb1

Syntax and Description of the DCOUNT Excel Function

The syntax for the DCOUNT function in Microsoft Excel is: DCOUNT(database, field, criteria) The database argument is a range of cells that makes up the database. The field argument is the column in the database that you want to count the values from. The criteria argument is the criteria that you want to use to count the values in the field.

About DCOUNT Excel Function

The DCOUNT function counts the cells that contain numbers in a column. Syntax: DCOUNT(database,field,criteria)