The * Database functions overview fully describes the use of these parameters.ĭCOUNTA counts non-empty cells, that is those cells containing numbers, text, TRUE/FALSE or errors.ĭCOUNTA(A1:E10 0 A13:E14) returns the number of children who are in the second grade (3).ĭCOUNTA(A1:E10 5 A13:E14) returns the number of children who are in the second grade, whose weight has either been measured or marked as "no" (1). ), or a column header (enclosed in quotation marks ””), or a cell referring to a column header, or 0 to include all columns.Ĭriteria_table is a range containing criteria, to select which rows of the database_table to count. It may be a column number (1 is the first column of the database table, 2 is the second. Counts the non-empty cells in a column of a Calc 'database' table, in rows which meet specified criteria.ĭCOUNTA(database_table field criteria_table)ĭatabase_table is a range defining the data to be processed.įield is the column to count.
0 kommentar(er)
