Calc Guide

Table 27. Using INDEX with a multi-range.
Function Returns
=INDEX(B2:G2; 1; 2) 93
=INDEX(B5:G5; 1; 2) 65
=INDEX((B2:G2;B5:G5); 1; 2) 93
=INDEX((B2:G2;B5:G5); 1; 2; 1) 93
=INDEX((B2:G2;B5:G5); 1; 2; 2) 65
Database-specific functions
Although every Calc function can be used for database manipulation,
the functions in Table 28 are specifically designed for use as a
database. The descriptions in Table 28 use the following terms
interchangeably: row and record, cell and field, and database and all
rows.
Table 28. Database functions in a Calc document.
Function Description
DAVERAGE Return the average of all fields that matches the search
criteria.
DCOUNT Count the number of records containing numeric data that
match the search criteria.
DCOUNTA Count the number of records containing text data that match
the search criteria.
DGET Return the contents of a field that matches the search
criteria.
DMAX Return the maximum content of a field that matches the
search criteria.
DMIN Return the minimum content of a field that matches the
search criteria.
DPRODUCT Return the product of the fields that matches the search
criteria.
DSTDEV Calculate the standard deviation using the fields that match
the search criteria. The fields are treated as a sample.
DSTDEVP Calculate the standard deviation using the fields that match
the search criteria. The fields are treated as the entire
population.
DSUM Return the sum of all fields that matches the search criteria.
Chapter 13 Calc as a Simple Database 387