Database Functions
- This topic is empty.
-
Posts
-
Rishabh Surana
The Database functions perform basic operations, such as Sum, Average, Count, etc., and additionally use criteria arguments, that allow you to perform the calculation only for a specified subset of the records in your Database. Other records in the Database are ignored. List of Database Functions:
DAVERAGE >>> Averages all numbers in a column in a list or database, based on a given criteria
DCOUNT >>> Returns the number of cells in a column or database that contains numeric values and meets a given criteria
DCOUNTA >>> Returns the number of cells in a column or database that contains nonblank values and meets a given criteria
DGET >>> Retrieves from a database a single record that matches a given criteria
DMAX >>> Returns the largest number in a column in a list or database, based on a given criteria
DMIN >>> Returns the smallest number in a column in a list or database, based on a given criteria
DPRODUCT >>> Returns the product of the numbers in a column in a list or database, based on a given criteria
DSTDEV >>> Returns the standard deviation of a population based on a sample of numbers
DSTDEVP >>> Returns the standard deviation of a population based on the entire population of numbers
DSUM >>> Sums the numbers in a column or database that meets a given criteria
DVAR >>> Returns the variance of a population based on a sample of numbers
DVARP >>> Returns the variance of a population based on the entire population of numbers
Sent from my SM-A605G using
Actuarial Info mobile app
- You must be logged in to reply to this topic.