Microsoft Office Tutorials and References
In Depth Information
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.
function can be used to
average columns or
lists of data.
as a column
Criteria constrained to all
numbers higher than 3,000
Field referenced as a
DCOUNT counts the number of cells containing numbers that meet the specified criteria.
The DCOUNT function tallies the number of cells containing numbers. Cells that contain text
and blank cells are ignored. To include text cells, use DCOUNTA (see upcoming section). If you
have a list or database, the database can be referenced as a cell reference or as a named
range. The field is the number of the column in the database from left to right or the column
heading in quotes (not case sensitive). The criteria is a range that contains the constraints the
function operates from. For example, let’s say you had a large database that had several blank
cells as well as cells containing numbers, only some of which you were interested in. The
criteria could specify to count all numbers having a value of more than 4,000 and less than
7,000, as shown in the third example in Figure 3.2. The criteria range is C20:C22, the field
reference is left blank so that the function searches the entire list (C5:F9).