Related Function:

The DAVERAGE function returns the average of values in a field (column) of records in a list or database  that matches conditions you that specify.




Argument Description
database A range of cells containing the database. The top row of the database should specify the field names
field Indicates the column of data for which the average is to be calculated

  The field can either be a field number, or can be the field name, i.e. the header in the top row of the database, encased in quotes, e.g. “Area”, “Quarter”, etc
criteria The range of cells that contain the conditions you specify

  The range can include one or more criteria, which are presented as a field name in one cell and the condition for that field in the cell below, e.g.

Gender Age
Male >10

Note: The criteria supplied beneath each field heading can be either:

  • a numeric value, including an integer, decimal, date, time, or logical value, e.g. 10, 01/01/2010, FALSE
  • a text string, e.g. “Name”, “Tuesday”
  • an expression, e.g. “>10”, “<>0”).

The Excel database functions are not case sensitive. So, for example, the criteria =”Math” will be satisfied by cells containing the text “Math” or “math”.


  A B C D E F G H
1 Quarter Area Sales Rep. Sales   Quarter Sales Rep.  
2 1 North Jeff $223,000   >1 Tina  
3 1 North Chris $125,000        
4 1 South Carol $456,000   Quarter Area  
5 1 South Tina $289,000   1 South  
6 2 North Jeff $322,000        
7 2 North Chris $340,000        
8 2 South Carol $198,000        
9 2 South Tina $222,000        
10 3 North Jeff $310,000        
11 3 North Chris $250,000        
12 3 South Carol $460,000        
13 3 South Tina $395,000        
14 4 North Jeff $261,000        
15 4 North Chris $389,000        
16 4 South Carol $305,000        
17 4 South Tina $188,000        
18 Formula Result Notes
19 =DAVERAGE(A1:D17,”Sales”,F1:G2) $268,333 Calculates the average of the values in cells D9, D13 & D17
20 =DAVERAGE(A1:D17,”Sales”,F4:G5) $372,500 Calculates the average of the values in cells D4 and D5

Note: You can also use the following wildcards in text-related criteria arguments:

      ?  –  matches any single character
  *  –  matches any sequence of characters

eg. the condition “A*e” will match any substring beginning with “A” and ending in “e”

If you do actually want to find the ? or * character, type the ~ symbol before this character in your search.