Learn how the DCOUNT function can be used to total the values in a column of data that meet the set criteria.

These instructions apply to Excel 2016, 2013, 2010, Excel 2019 for Mac, Excel 2016 for Mac, Excel for Mac 2011, Excel for Office 365, and Excel Online.

### DCOUNT Syntax and Arguments

The DCOUNT function is one of Excel's database functions. This group of functions is designed to make it easy to summarize information from large tables of data. They do this by returning specific information based on one or more criteria chosen by the user.

= DCOUNT ( database, field, criteria )

All database functions have the same three arguments:

**Database**: (required) Specifies the range of cell references containing the database. The field names must be included in the range.**Field**: (required) Indicates which column or field is to be used by the function in its calculations. Enter the argument either by typing the field name in quotes, such as "Radius" or enter the column number, such as 3.**Criteria**: (required) Lists the range of cells containing the conditions specified by the user. The range must include at least one field name from the database and at least one other cell reference indicating the condition to be evaluated by the function.

This example will use DCOUNT to find the total number of students enrolled in the first year of their college program.

### Entering the Tutorial Data

The tutorial does not include formatting steps. Information on worksheet formatting options is available in this Basic Excel Formatting Tutorial.

- Enter the data table as seen in the image above into cells
**D1 to F15.** - Leave cell
**F5**blank. This is where the DCOUNT formula will be located. - The field names in cells D2 to F2 will be used as part of the function's
*Criteria*argument.

### Selecting the Criteria

To get DCOUNT to only look at data for first-year students, we enter the number 1 under the *Year* field name in row 3.

- In cell
**F3**type the criteria**1**. - In cell
**E5**type the heading**Total:**

### Naming the Database

Using a named range for large ranges of data such as a database can not only make it easier to enter this argument into the function, but it can also prevent errors caused by selecting the wrong range.

Named ranges are very useful if you use the same range of cells frequently in calculations or when creating charts or graphs.

- Highlight cells
**D6 to F15**in the worksheet to select the range. - Click on the name box above column A in the worksheet.
- Type
**Enrollment**into the name box to create the named range. - Press the
**Enter**key on the keyboard to complete the entry.

### Opening the DCOUNT Dialog Box

A function's dialog box provides an easy method for entering data for each of the function's arguments.

Opening the dialog box for the database group of functions is done by clicking on the function wizard button (fx) located next to the formula bar above the worksheet - see image above.

- Click on cell
**F5**, which is the location where the results of the function will be displayed. - Click on the
**Insert Function**button. - Type
**DCOUNT**in the Search for a function window at the top of the dialog box. - Click on the
**Go**button to search for the function. - The dialog box should find DCOUNT and list it in the Select a function window.
- Click
**OK**to open the DCOUNT function dialog box.

The function dialog box is not available in Excel Online. Instead, you can use the Insert Function button.

- Click on cell
**F5**, which is the location where the results of the function will be displayed. - Click on the
**Insert Function**button. - Select
**All**in the Pick a Category list. - Scroll down to
**DCOUNT**and click to select it. - Click
**OK.**The formula syntax and arguments appear.

### Completing the Arguments

- Click on the
**Database**line of the dialog box. - Type the range name
**Enrollment**into the line. - Click on the
**Field**line of the dialog box. - Type the field name
*"Year"*into the line. Be sure to include the quotation marks. - Click on the
**Criteria**line of the dialog box. - Highlight cells
**D2 to F3**in the worksheet to enter the range. - Click
**OK**to close the DCOUNT function dialog box and complete the function.

In Excel Online, enter **=DCOUNT(Enrollment, "Year", D2:F3) **manually into the formula bar.

The answer **3** should appear in cell F5 since only three records (those in rows 7, 10, and 13) show the student as enrolled in the first year of their program.

When you click on cell F5 the complete function**=DCOUNT(Enrollment, "Year", D2:F3)** appears in the formula bar above the worksheet.

If we wanted to find the total number of students enrolled, we could use the regular COUNT function, since we do not need to specify criteria to limit what data is used by the function.

### Database Function Errors

**#Value**: Occurs most often when the field names were not included in the database argument.

For the example above, be sure that the field names in cells D6:F6 were included in the named range Enrollment.