Monday, October 26, 2009

excel database functions


1. DAVERAGE averages the values in a column in a list
or database that match conditions you specify.
2. DCOUNT counts the cells containing numbers in the
field (columns) of records in the database that match
the conditions you specify.
3. DCOUNTA counts nonblank cells in the field (column) of records
in the database that match the conditions you specify.
4. DGET extracts from a database a single record that matches
the conditions you specify.
5. DMAX returns the largest number in the field (column) of
records in the database that match the conditions you specify.
6. DMIN returns the smallest number in the field (column)
of records in the database that match the conditions you specify.
7. DPRODUCT multiplies the values in the field (column) of
records in the database that match the conditions you specify.
8. DSTDEV estimates the standard deviation based on a sample
from selected database entries.
9. DSTDEVP calculates the standard deviation based on the entire
population of selected database entries.
10. DSUM adds the numbers in the field (column) of records
in the database that matches the conditions you specify.
11. DVAR estimates variance based on a sample from selected
database entries.
12. DVARP calculates variance based on the entire population
of selected database entries.

No comments:

Post a Comment