Database functions
Title | Detail | Text |
|---|---|---|
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 |