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 |
Returns the average of selected database entries |
|
Counts the cells that contain numbers in a database |
|
Counts nonblank cells in a database |
|
Extracts from a database a single record that matches the specified criteria |
|
Returns the maximum value from selected database entries |
|
Returns the minimum value from selected database entries |
|
Multiplies the values in a particular field of records that match the criteria in a database |
|
Estimates the standard deviation based on a sample of selected database entries |
|
Calculates the standard deviation based on the entire population of selected database entries |
|
Adds the numbers in the field column of records in the database that match the criteria |
|
Estimates variance based on a sample from selected database entries |
|
Calculates variance based on the entire population of selected database entries |