How to use the Excel DAVERAGE function

The DAVERAGE Function in Excel is used to determine the average amount of data records within a range of data that matches a specific criteria. This tutorial will step through how to use the DAVERAGE function.

Syntax: =DAVERAGE(database, field, criteria)

The DAVERAGE function syntax has the following arguments:

  • database – Database range including headers.
  • field – Field name or index to count.
  • criteria – Criteria range including headers.

Example: Let’s look at some Excel DAVERAGE function examples and explore how to use the DAVERAGE function as a worksheet function in Microsoft Excel:

Excel DAVERAGE function 1 - How to use the Excel DAVERAGE function

1. Syntax: =DAVERAGE(H7:L17,L7,J19:K20)

Result:

Excel DAVERAGE function 2 - How to use the Excel DAVERAGE function

2. Syntax: =DAVERAGE(H7:L17,L7,J19:K20)

Result:

Excel DAVERAGE function 3 - How to use the Excel DAVERAGE function

Note: The Excel DAVERAGE function gets the average in a given field for a subset of records that match criteria. The database argument is a range of cells that includes field headers, field is the name or index of the field to get a max value from, and criteria is a range of cells with headers that match those in database.

Add a Comment

Your email address will not be published. Required fields are marked *