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.
Diffrent way to use the DAVERAGE function...
DAVERAGE Function Error:
- #DIV/0! error:
- Occurs if the given criteria not find any value in dataset or not available in dataset or data table.
The Criteria argument can include in variety of expressions.
| Criteria Syntax | Criteria Meaning / Behavior |
|---|---|
| Black | Match "black" or "BLACK" |
| Be* | Begins with "be" |
| 7 | Equal to 7 |
| <>7 | Not 7 |
| >11/25/2012 | Greater than Nov 25, 2012 |
| <> | Not blank |
Download Example Sample Excel File
daverage-function-example.xlsx