# MS Excel: DCOUNTA Function (WS)

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

## Description

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

## Syntax

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

DCOUNTA( range, field, criteria )

### Parameters or Arguments

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

*field* is the column to count the values. You can either specify the numerical position of the column in the list or the column label in double quotation marks.

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

## Applies To

The **DCOUNTA 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 **DCOUNTA 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 DCOUNTA function examples and explore how to use the **DCOUNTA function** as a worksheet function in Microsoft Excel:

Based on the spreadsheet above, the following Excel **DCOUNTA examples** would return:

=DCOUNTA(A4:D8, "Unit Cost", A1:B2) | would return 2 |

=DCOUNTA(A4:D8, 3, A1:B2) | would return 2 |

=DCOUNTA(A4:D8, "Quantity", A1:A2) | would return 3 |

=DCOUNTA(A4:D8, 2, A1:A2) | would return 3 |

### Using Named Ranges

You can also use a named range in the **DCOUNTA 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 spreadsheet above, the following Excel **DCOUNTA examples** would return:

=DCOUNTA(orders, "Total Cost", A1:B2) | would return 2 |

=DCOUNTA(orders, 4, A1:B2) | would return 2 |

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