MSOfficeExcel 2007 Tutorial Database Functions 17 codes

1 Database functions

2 DCOUNT(database,field,criteria) counts the cells that contain numbers in a database

3 DCOUNTA(database,field,criteria) counts nonblank cells in a database

4 DGET(database,field,criteria) extracts from a database a single record that matches the specified criteria

5 DMAX(database,field,criteria) returns the maximum value from selected database entries

6 DMIN(database,field,criteria) returns the minimum value from selected database entries

7 DPRODUCT(database,field,criteria) multiplies the values that match the criteria in a database

8 DSTDEV(database,field,criteria) estimates the standard deviation based on selected database entries

9 DSTDEVP(database,field,criteria) calculates the standard deviation

10 DSUM(database,field,criteria) adds the numbers in the database

11 DVAR(database,field,criteria) estimates variance based on a sample from selected database entries

12 DVARP(database,field,criteria) calculates variance based on the selected database entries

13 Use greater than

14 Use the equals sign ==entry

15 Use the equals sign with text

16 Use the equals sign with value

17 Use wild card character