DAVERAGE | Returns the mean value from the selected database entries |
DCOUNT | Counts the cells in a database that contain numbers |
DCOUNTA | Counts the cells in a database that are not empty |
DGET | Reads a data record from a database that meets the specified search criteria |
DMAX | Returns the highest value from the selected database entries |
DMIN | Returns the lowest value from the selected database entries |
DPRODUCT | Multiplies the values in a field of the database records that meets the specified conditions |
DSTDEV | Calculates the standard variance using a sample of database entries |
DSTDEVP | Calculates the standard variance using the population from database entries |
DSUM | Adds the numbers in the column field in the database records that meet the specified conditions |
DVAR | Calculates the variance using a sample of database entries |
DVARP | Calculates the variance using the population from database entries |