Learn Excel - Simplify Life with Excel Concepts

## Excel DAVERAGE Function

### How to use the DAVERAGE Function

This Excel tutorial explains how to use the Excel DAVERAGE function with syntax and examples.

### SUMMARY:

The Excel DAVERAGE function averages all numbers values in a column of datatable or database, based on a given conditions.

For example,

• The formula =DAVERAGE(D7:G14,"Price",D4:E5) would return 45000 average Price of Laptop in the database where price >=30000.
• The formula =DAVERAGE(D7:G14,2,D4:E5) would return 45000 average Price of Laptop in the database where price >=30000.

### PURPOSE:

To Get the Average value based on given Criteria.

### RETURN VALUE:

The DAVERAGE function returns a Numeric value.

### SYNTAX:

DAVERAGE(database, field, criteria)

### ARGUMENTS:

The DAVERAGE function syntax has the following arguments:

• database: Required. The range of cells that makes up the list or database including data headers.
• field: Required. The table header name or index number of header.
• criteria: Required. The range of cells that contains your criteria including data headers.

### REMARKS:

• The database argument is a range of cells that includes field headers.
• The criteria can include a variety of expressions, including some wildcards.
• The DAVERAGE function supports wildcards in criteria.
• The Criteria can include more than one row.
• The database and criteria ranges must include matching headers.