Excel Database Function Codes
I’ve listed some database function codes for Excel. If you are working on a database within Excel, this tool can be quite useful. You can find more function codes at Microsoft.com.
Happy databasing!
Colleen M. Johnson, CMJ Office
Database Functions
|
Function |
Description |
|
DAVERAGE |
Returns the average of selected database entries |
|
DCOUNT |
Counts the cells that contain numbers in a database |
|
DCOUNTA |
Counts nonblank cells in a database |
|
DGET |
Extracts from a database a single record that matches the specified criteria |
|
DMAX |
Returns the maximum value from selected database entries |
|
DMIN |
Returns the minimum value from selected database entries |
|
DPRODUCT |
Multiplies the values in a particular field of records that match the criteria in a database |
|
DSTDEV |
Estimates the standard deviation based on a sample of selected database entries |
|
DSTDEVP |
Calculates the standard deviation based on the entire population of selected database entries |
|
DSUM |
Adds the numbers in the field column of records in the database that match the criteria |
|
DVAR |
Estimates variance based on a sample from selected database entries |