DAVERAGE
DAVERAGE indicates the average of the values that meet the specified criteria.
=DAVERAGE(database,field,criteria)
The DAVERAGE function averages the range of numbers that span over a range based on criteria you specify. The criteria is the range containing restrictions on which data should be included in the calculation. This means that you can specifically call out parameters, such as the sum of all numbers greater than 30, with the DSUM function. The DAVERAGE function counts the total number of entries and divides the total of the numbers by the number of entries. When sampling data, populations, or analyzing sales data over large ranges, the DAVERAGE function quickly summarizes and returns the average. Notice the example in Figure 3.1. The field can be referenced as a column number, as shown in column 4. The 4 represents the number of columns starting from left to right. In the second example the field is referenced as a column heading "1999." The column heading is text and needs to be in quotes. The third example also references column 4, however, the criteria in range C21:C22 shows the criteria as all numbers that exceed 3,000 and less than 7,000.
Figure 3.1 The DAVERAGE function can be used to average columns or lists of data.