Microsoft Office Tutorials and References

In Depth Information

**DSUM**

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.

A

Database range

Figure 3.6

The
DSTDEVP
function

calculates the true

standard deviation

of an entire population,

in this case, all the

communities in the

year 2001.

C

The criteria to include

on the list

B

Field referenced as text

DSU
DSUM
returns the total of the values that meet the specified criteria.

=DSUM(database,field,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.