
DAVERAGE function in Excel
2007:
Averages the data in an
Excel worksheet
column
or field based on the criteria you specify. Let's say a teacher has a
database of her students in Excel and she wishes to find the average
marks or grades her students have achieved in Math. Daverage is the
function to use. Or, a researcher wishes to know which model of a TV is
purchased by which age group. Also, the General Manager of a sales team
would like to know what is the average sales of his team in a certain
area.
Syntax
DAVERAGE(database,field,criteria)

Database
is the range of cells
that makes up the list or database. In our example in the video it is
'A1:C11'. A database is a list of related data in which rows of related
information are records, and columns of data are fields. The first row
of the list contains labels like 'Name', 'Gender' and 'Age'.
Field speifies which column is used
in the
daverage function. Enter the column label enclosed between double
quotation marks, such as "Age" or "Male" or a number 2 or 3 (without
quotation marks) that represents the position of the column within the
list: 1 for the first column, 2 for the second column, and so on.
Criteria is the range of cells that
contains
the conditions you specify. You can use any range for the criteria
argument, as long as it includes at least one column label and at least
one cell below the column label in which you specify a condition for
the column. We have specified the criteria 'Male' and '>=30'
below
the labels 'Gender' and 'Age' respectively.
Once you have the data in place, you copy and paste the headers in an
appropriate position on your Excel worksheet. Try avoiding pasting the
headers below your data in case you wish to add more data later on. Now
under the pasted header, as shown in the Excel training video and
mentioned
above, you define the data from which you wish to calculate the average
from a specific column and the criteria like , in our example, '="Male"
' and ' ">=30" ' under the 'Gender' and 'Age' columns
respectively.
As you can see the average age of males greater than or equal to 30
works
out to '40'.
