# MS Excel: DCOUNT Function (WS)

Learn how to use the Excel **DCOUNT function** with syntax and examples.

## Description

The Microsoft Excel **DCOUNT function** returns the number of cells in a column or database that contains numerc values and meets a given criteria.

## Syntax

The syntax for the Microsoft Excel **DCOUNT function** is:

DCOUNT( range, [field], criteria )

### Parameters or Arguments

*range* is the range of cells that you want to apply the *criteria* against.

*field* is optional. It is the column to count the numeric values that meet the *criteria*. You can either specify the numerical position of the column in the list or the column label in double quotation marks. If *field* is omitted, the **DCOUNT function** will count all records that match the *criteria*.

*criteria* is the range of cells that contains your criteria.

## Applies To

The **DCOUNT function** can be used in the following versions of Microsoft Excel:

- Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

## Type of Excel Function

The **DCOUNT function** can be used in Microsoft Excel as the following type of function:

- Worksheet function (WS)

## Example (as Worksheet Function)

Let's look at some Excel DCOUNT function examples and explore how you would use the **DCOUNT function** as a worksheet function in Microsoft Excel:

Based on the Excel spreadsheet above, you could use the **DCOUNT function** as follows:

=DCOUNT(A4:D8, "Unit Cost", A1:B2)

The **DCOUNT function** example above would return 2 because in the range A4:D8, there are 2 occurrences that meet the conditions in A1:B2. Those conditions are OrderID > 10567 and Quantity >= 4. By specifying "Unit Cost" as the second parameter, the **DCOUNT function** will only count the numeric values in the "Unit Cost" column that meet the *criteria*. If a value in the "Unit Cost" column is not numeric, it will not be included in the **DCOUNT function** calculations.

We could modify the **DCOUNT function** example as follows to specify the 3rd position in the range A4:D8 instead of "Unit Cost":

=DCOUNT(A4:D8, 3, A1:B2)

This would return the same results as the first example, except instead of using "Unit Cost" as the second parameter we use 3 to specify the third position in the range A4:D8.

We could also omit the *field* parameter if we want to count all of the records that match the conditions in A1:B2 (and we don't really care about counting numeric values in a particular *field*) as follows:

=DCOUNT(A4:D8, , A1:B2)

We could limit our criteria to only A1:A2 with the following **DCOUNT function** example:

=DCOUNT(A4:D8, , A1:A2)

This example would return 3 because in the range A4:D8, there are 3 occurrences that meet the condition in A1:A2. That condition is OrderID > 10567. Note: we aren't checking a particular *field* for numeric values so the second parameter is omitted.

### Using Named Ranges

You can also use a named range in the **DCOUNT function**. For example, we've created a named range called *orders* that refers to Sheet1!$A$4:$D$8.

Then we've entered the following data in Excel:

Based on the Excel spreadsheet above, we could replace the range A4:D8 with the named range called *orders*. Our **DCOUNT function** could be modified as follows:

=DCOUNT(orders, , A1:A2)

To view named ranges: Under the Insert menu, select Name > Define.