Calc Guide

Function Description
DVAR Calculate the variance using the fields that match the search
criteria. The fields are treated as a sample.
DVARP Calculatesthe variance using the fields that match the
search criteria. The fields are treated as the entire
population.
The syntax for the database functions are identical.
DCOUNT(database; database field; search criteria)
The database argument is the cell range that defines the database. The
cell range should contain the column labels (see Listing 22). The
following examples, assume that the data from Table 12 is placed in
Sheet 1 and the filter criteria in Table 15 is placed in Sheet 2.
Listing 22. The database argument includes the headers.
=DCOUNT(A1:G16; "Test 2"; Sheet2.A1:G3)
The database field specifies the column on which the function operates
after the search criteria is applied and the data rows are selected. The
database field can be specified using the column header name or as an
integer. If the column is specified as an integer, 0 specifies the entire
data range, 1 specifies the first column, 2 specifies the second column,
and so on. Listing 23 calculates the average test score for the rows
that match the search criteria.
Listing 23. “Test 2” is column 3.
=DAVERAGE(A1:G16; "Test 2"; Sheet2.A1:G3)
=DAVERAGE(A1:G16; 3; Sheet2.A1:G3)
The search criteria is the cell range containing search criteria. The
search criteria is identical to the advanced filters; criteria in the same
row is connected by AND and criteria in different rows is connected by
OR.
Conclusion
A Calc document provides sufficient database functionality to satisfy
the needs of most people. The infrequently used database functions,
such as OFFSET and INDEX, are worth the time to learn and they can
save yourself time in the long run.
388 OpenOffice.org 3.x Calc Guide