Microsoft Office Tutorials and References
In Depth Information
In the example in Figure 3.6, the true standard deviation in the communities’ population for
the year 2001 is 1,233. Notice how the criteria takes into account a vertical range of towns the
criteria calculates from. If the range were B13:B15, it would only include the populations of
Avon and Albany in the year 2001.
The DSTDEVP function
calculates the true
of an entire population,
in this case, all the
communities in the
The criteria to include
on the list
Field referenced as text
DSU DSUM returns the total of the values that meet the specified criteria.
The DSUM function operates much as the sum function except that it operates on a database
with criteria. The database is the cell reference range or named range of the database, and
the field is referenced as the column number from left to right. The criteria is a range that is
referenced, and the function operates from the parameters set. The field can also be a cell
reference. The criteria enable you to apply constraints, as shown in the example in Figure
3.7. Notice the criteria applies the sum of all sales for the cars greater than 1995 and less than
2000. The sum of sales dollars from 1996 through 1999 equals $2,034,572.