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

Part VIII: Appendixes > Database Functions

Database Functions

When you use Excel for data management, you often want to perform some of the simple mathematical operations on ranges of data, but only with a subset that matches some criteria. Using the database functions, you can do just that. Review Table B.1 to see what database functions are available for use in your data management projects.

Table B.1. Database Functions in Excel
Function SyntaxReturns
=DAVERAGE(database,field,criteria)Average of cells within a database field that match the criteria
=DCOUNT(database,field,criteria)Count of cells within a database field that match the criteria
=DCOUNTA(database,field,criteria)Count of non-blank cells within a database field that match the criteria
=DGET(database,field,criteria)Record from a database that matches the criteria
=DMAX(database,field,criteria)Maximum value from a database field within records that match the criteria
=DMIN(database,field,criteria)Minimum value from a database field within records that match the criteria
=DPRODUCT(database,field,criteria)Product of cells within a field where the rows match the criteria
=DSTDEV(database,field,criteria)Estimated standard deviation based on a sample of records that meet the criteria
=DSTDEVP(database,field,criteria)Standard deviation based on an entire population of records that match the criteria
=DSUM(database,field,criteria)Sum of a field within records that match the criteria
=DVAR(database,field,criteria)Estimated variance of a field based on a sample of records that match the criteria
=DVARP(database,field,criteria)Variance of a field (based on total population) within records that match the criteria
=GETPIVOTDATA(pivot_table,name)Data stored within a PivotTable



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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