Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Excel
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Database functions (reference)
 

Click one of the links in the following list to see detailed help about the function.

FunctionDescription
DAVERAGEReturns the average of selected database entries
DCOUNTCounts the cells that contain numbers in a database
DCOUNTACounts nonblank cells in a database
DGETExtracts from a database a single record that matches the specified criteria
DMAXReturns the maximum value from selected database entries
DMINReturns the minimum value from selected database entries
DPRODUCTMultiplies the values in a particular field of records that match the criteria in a database
DSTDEVEstimates the standard deviation based on a sample of selected database entries
DSTDEVPCalculates the standard deviation based on the entire population of selected database entries
DSUMAdds the numbers in the field column of records in the database that match the criteria
DVAREstimates variance based on a sample from selected database entries
DVARPCalculates variance based on the entire population of selected database entries
advertisement