Calc Guide

Function Description
SUMIF Calculate the sum for the cells that meet the search
criteria.
VAR Estimate the variance based on a sample.
VARA Estimate the variance based on a sample. The value of
text is 0.
VARP Estimate the variance based on the entire population.
VARPA Estimate the variance based on the entire population. The
value of a text is 0.
VLOOKUP Search for a specific value across the rows in the first
column of an array. Returns the value from a different
column in the same row.
Most of the functions in Table 17 require no explanation, either
because they are well understood (SUM, for example) or because if you
need to use them then you know what they are (STDEV, for example).
Unfortunately, some of the more useful functions are infrequently used
because they are not well understood.
Count and sum cells that match conditions: COUNTIF
and SUMIF
The COUNTIF and SUMIF functions calculate their values based on
search criteria. The search criteria can be a number, expression, text
string, or even a regular expression. The search criteria can be
contained in a referenced cell or it can be included directly in the
function call.
The COUNTIF function counts the number of cells in a range that
match specified criteria. The first argument to COUNTIF specifies the
range to search and second argument is the search criteria. Table 18
illustrates different search criteria using the COUNTIF function
referencing the data shown in Table 12.
The first two arguments for SUMIF serve the same purpose as the
arguments for COUNTIF; the range that contains the cells to search
and the search criteria. The third and final argument for SUMIF
specifies the range to sum. For each cell in the search range that
matches the search criteria, the corresponding cell in the sum range is
added into the sum.
Chapter 13 Calc as a Simple Database 377