Monday, August 6, 2018

Database functions (reference)

Database functions (reference)

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

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

Function

Description

DAVERAGE function

Returns the average of selected database entries

DCOUNT function

Counts the cells that contain numbers in a database

DCOUNTA function

Counts nonblank cells in a database

DGET function

Extracts from a database a single record that matches the specified criteria

DMAX function

Returns the maximum value from selected database entries

DMIN function

Returns the minimum value from selected database entries

DPRODUCT function

Multiplies the values in a particular field of records that match the criteria in a database

DSTDEV function

Estimates the standard deviation based on a sample of selected database entries

DSTDEVP function

Calculates the standard deviation based on the entire population of selected database entries

DSUM function

Adds the numbers in the field column of records in the database that match the criteria

DVAR function

Estimates variance based on a sample from selected database entries

DVARP function

Calculates variance based on the entire population of selected database entries

See Also

Excel functions (by category)

Excel functions (alphabetical)

No comments:

Post a Comment