12/13/2023 0 Comments Intervalo de paginas para imprimirSearchCriteria specifies the range of cells containing search criteria. The DatabaseField argument is optional for the DCOUNT and DCOUNTA functions but it is required for the other ten Database functions. You can also provide a reference to an arbitrary cell (not within the Database and SearchCriteria areas) that contains the required string. If the string does not match one of the Database area’s column headings, Calc reports Err:504 (error in parameter list). If the value is greater than the number of columns in Database, Calc reports a #VALUE! error.īy entering the literal column header name from the first row of the Database range, placing quotation marks around the header name. If the value is less than 1, Calc reports Err:504 (error in parameter list). Calc expects an integer value that lies between 1 and the number of columns defined within Database and ignores any digits after a decimal point. For example, if a Database occupied the cell range D6:H123, then enter 3 to indicate the header cell at F6. If the name is valid but does not correspond to one cell only, Calc reports Err:504 (error in parameter list).īy entering a number to specify the column within the Database area, starting with 1. If the name does not match the name of a defined range, Calc reports a #NAME? error. Alternatively, if the cell has been given a meaningful name as a named range or database range, enter that name. Specify the DatabaseField argument in any of the following ways:īy entering a reference to a header cell within the Database area. It is not related to the search criteria. Other errors that might be reported as a result of an invalid Database argument are #VALUE! and Err:504 (error in parameter list).ĭatabaseField specifies the column which the function will use for its calculations after the search criteria have been applied and the data rows have been selected. Using a meaningful name to define the cell range can enhance formula readability and document maintenance. The Database argument may also be specified by passing the name of a named range or database range. One way of defining the range of cells is to enter the cell reference for the upper left-hand cell, followed by a colon (:), and then the lower right-hand cell reference. The first row of the range contains the field names, and subsequent rows are records with corresponding field values. Las definiciones de argumentos siguientes se aplican a todas las funciones de la categoría Base de datos:ĭatabase specifies the range of cells occupied by the database table. The values processed are those in the DatabaseField column of the selected records.Ĭalc trata los datos y los valores lógicos (VERDADERO y FALSO) como numéricos al calcular con estas funciones.Īrgumentos de las funciones de base de datos The second step is to extract the data values and perform the calculations associated with the specific function (average, sum, product, and so on). The first logical step is to use the specified SearchCriteria to identify the subset of records in the Database that are to be used during subsequent calculations. The cell range of a separate area of the spreadsheet containing search criteria.Įstos argumentos se describen a detalle más abajo.Īll functions have the same outline concept of operation. The column containing the data to be used in the function’s calculations. El intervalo de celas de la base de datos.ĭatabaseField. Las funciones de la categoría Base de datos aceptan estos tres argumentos:īase de datos. La celda de cabecera de cada columna muestra el nombre de esta y este nombre normalmente refleja el contenido de cada celda de esa columna en particular. Las doce funciones de la categoría Base de datos le ayudan a analizar una base de datos sencilla que ocupa un área rectangular en una hoja de cálculo, compuesta de columnas y de filas, con los registros individuales organizados en filas. Funciones de bases de datos Información general
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |