Database spreadsheet functions
The database spreadsheet functions are similar to the statistical spreadsheet functions. Instead of taking a simple list of values, these spreadsheet functions all take three arguments, as in @DMAX(Block,Column,Criteria).
|
•
|
|
@DAVG The average (mean) of all numeric values in specified cells.
|
|
•
|
|
@DCOUNT The number of nonblank cells in specified cells.
|
|
•
|
|
@DGET A value or label from cells.
|
|
•
|
|
@DMAX The largest numeric or latest date value in specified cells.
|
|
•
|
|
@DMIN The smallest numeric or earliest date value in specified cells.
|
|
•
|
|
@DPRODUCT The product of values in specified cells.
|
|
•
|
|
@DPURECOUNT A count of all numeric entries in specified cells.
|
|
•
|
|
@DSTD The population standard deviation of all values in specified cells.
|
|
•
|
|
@DSTDS The sample standard deviation of all values in specified cells.
|
|
•
|
|
@DSUM The total of all numeric values in specified cells.
|
|
•
|
|
@DVAR The population variance of all values in specified cells.
|
|
•
|
|
@DVARS The sample variance of all values in specified cells.
|