OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 331)

Function Description

STDEV Estimate the standard deviation based on a sample.

STDEVA Estimate the standard deviation based on a sample. The value of

text is 0.

STDEVP Calculate the standard deviation based on the entire population.

STDEVPA Calculate the standard deviation based on the entire population.

SUBTOTAL Calculate a specified function based on a subset created using

AutoFilters.

SUM Return the sum of the cells.

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 23.

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 331

1 2 ... 326 327 328 329 330 331 332 333 334 335 336 ... 433 434

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 331