• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Database Functions

Database Functions

DAVERAGE(database,field,criteria) Returns the average of selected database entries.
DCOUNT(database,field,criteria) Counts the cells containing numbers from a specified database and criteria.
DCOUNTA(database,field,criteria) Counts nonblank cells from a specified database and criteria.
DGET(database,field,criteria) Extracts from a database a single record that matches the specified criteria.
DMAX(database,field,criteria) Returns the maximum value from selected database entries.
DMIN(database,field,criteria) Returns the minimum value from selected database entries.
DPRODUCT(database,field,criteria) Multiplies the values in a particular field of records that match the criteria in a database.
DSTDEV(database,field,criteria) Estimates the standard deviation based on a sample of selected database entries.
DSTDEVP(database,field,criteria) Calculates the standard deviation based on the entire population of selected database entries.
DSUM(database,field,criteria) Adds the numbers in the field column of records in the database that match the criteria.
DVAR(database,field,criteria) Estimates the variance based on a sample from selected database entries.
DVARP(database,field,criteria) Calculates variance based on the entire population of selected database entries.
GETPIVOTDATA(pivot_table,name) Returns data stored in a pivot table.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint