Contents
An Introduction to Excel Functions
Financial Functions
Date and Time Functions
Math and Trigonometry Functions
Statistical Functions
Lookup and Reference Functions
Database Functions
Text Functions
Logical Functions
Information Functions
Engineering Functions
Cube Functions
Add-In and Automation Functions
|
 |
 |
 |
|
Database Functions
Function |
Description |
Syntax |
||
DAVERAGE |
Returns the average of selected database entries |
(database,field,criteria) |
||
DCOUNT |
Counts the cells that contain
numbers in a database |
(database,field,criteria) |
||
DCOUNTA |
Counts nonblank cells in
a database |
(database,field,criteria) |
||
DGET |
Extracts from a database a
single record that matches the specified criteria |
(database,field,criteria) |
||
DMAX |
Returns the maximum value from selected database entries |
(database,field,criteria) |
||
DMIN |
Returns the minimum value from selected database entries |
(database,field,criteria) |
||
DPRODUCT |
Multiplies the values in a particular field of records that match the criteria in a database |
(database,field,criteria) |
||
DSTDEV |
Estimates the standard deviation based on a sample of selected database entries |
(database,field,criteria) |
||
DSTDEVP |
Calculates the standard deviation based on the entire population of selected database entries |
(database,field,criteria) |
||
DSUM |
Adds the numbers in the field column of records in the database that match the criteria |
(database,field,criteria) |
||
DVAR |
Estimates variance based on
a sample from selected
database entries |
(database,field,criteria) |
||
DVARP |
Calculates variance based on the entire population of selected
database entries |
(database,field,criteria) |
| Acknowledgments & Disclaimer |
Tags
No one has tagged this page yet... Be the first.. Log in using the link below and return to add your tag
