![]() ![]() SearchCriteria is the cell range containing search criteria. To reference a column by means of the literal column header name, place quotation marks around the header name. For the DatabaseField parameter you can enter a reference to a header cell or a number to specify the column within the Database area, starting with 1. ![]() It is not related to the search criteria itself. The following items are the parameter definitions for all database functions:ĭatabase is the cell range defining the database.ĭatabaseField specifies the column where the function operates on after the search criteria of the first parameter is applied and the data rows are selected. The formula in cell B16 is =DCOUNT(A1:E10 D1 A13:E14) Database Function Parameters: The following information is given for each entry: column A shows the name, B the grade, then age in years, distance to school in meters and weight in kilograms. The range A1:E10 lists the children invited to Joe's birthday party. The following data will be used in some of the function description examples: However, there is no connection between a database in LibreOffice and the Database category in LibreOffice Calc. ![]() The Database category may be confused with a database integrated in LibreOffice. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |