Calc Guide

Syntax Description
DCOUNTA(database;
database_field;
search_criteria)
Counts the number of rows (records) in a database
that match the specified search_criteria and
contain numeric or alphanumeric values. The
search supports regular expressions.
DGET(database;
database_field;
search_criteria)
Returns the contents of the referenced cell in a
database which matches the specified
search_criteria. In case of an error, the function
returns either #VALUE! for no row found, or
Err502 for more than one cell found.
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.
Appendix B Description of Functions 467