# MS Excel: DAVERAGE Function (WS)

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

## Description

The Microsoft Excel **DAVERAGE function** averages all numbers in a column in a list or database, based on a given criteria.

## Syntax

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

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

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

=DAVERAGE(A4:D8, "Unit Cost", A1:B2) | would return 3.995 |

=DAVERAGE(A4:D8, 3, A1:B2) | would return 3.995 |

=DAVERAGE(A4:D8, "Quantity", A1:A2) | would return 6.666667 |

=DAVERAGE(A4:D8, 2, A1:A2) | would return 6.666667 |

### Using Named Ranges

You can also use a named range in the **DAVERAGE 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 **DAVERAGE examples** would return:

=DAVERAGE(orders, "Total Cost", A1:B2) | would return 30.44 |

=DAVERAGE(orders, 4, A1:B2) | would return 30.44 |

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