Calc Guide

Syntax Description
DMAX(database;
database_field;
search_criteria)
Returns the maximum content of a cell (field) in a
database (all records) that matches the specified
search_criteria. The search supports regular
expressions.
DMIN(database;
database_field;
search_criteria)
Returns the minimum content of a cell (field) in a
database that matches the specified search_criteria.
The search supports regular expressions.
DPRODUCT(database;
database_field;
search_criteria)
Multiplies all cells of a data range where the cell
contents match the search_criteria. The search supports
regular expressions.
DSTDEV(database;
database_field;
search_criteria)
Calculates the standard deviation of a population based
on a sample, using the numbers in a database column
that match the search_criteria. The records are treated
as a sample of data. Note that a representative result of a
large population can not be obtained from a sample of
fewer than one thousand.
DSTDEVP(database;
database_field;
search_criteria)
Calculates the standard deviation of a population based
on all cells of a data range which match the
search_criteria. The records from the example are
treated as the whole population.
DSUM(database;
database_field;
search_criteria)
Returns the total of all cells in a database field in all rows
(records) that match the specified search_criteria. The
search supports regular expressions.
DVAR(database;
database_field;
search_criteria)
Returns the variance of all cells of a database field in all
records that match the specified search_criteria. The
records from the example are treated as a sample of
data. A representative result of a large population cannot
be obtained from a sample population of fewer than one
thousand.
DVARP(database;
database_field;
search_criteria)
Calculates the variance of all cell values in a database
field in all records that match the specified
search_criteria. The records are from the example are
treated as an entire population.
Array functions
Table 42: Array functions
Syntax Description
FREQUENCY(data;
classes)
Calculates the frequency distribution in a one-column-
array. The default value supply and the number of
intervals or classes are used to count how many values
are omitted on the single intervals. Data is the array of,
or reference to, the set of values to be counted. Classes
is the array of the class set.
408 OpenOffice.org 3.3 Calc Guide