The exact use of 0 as the field parameter is unclear, both in operation and in compatibility. In A10 you want to show how many cells have a value (9. But if you want to count the number of cells in which it occurs a value The non-empty cells so. A few more notes when using these formulas The COUNTA function is used when the data is perfect, meaning, with no unnecessary characters like apostrophe and space. OpenOffice Calc is a standard formula for counting empty cells: COUNTBLANK (range). Irene is included, because her weight is marked as 'no', which is text.ĭCOUNTA(A1:E10 E1 A13:E14) also returns the number of children in the second grade whose weight has either been measured or marked as 'no' (1). On the other hand, COUNTA function counts numbers, texts, dates, characters and even spaces. COUNTIF (A2:A12 '') will count that cell. Frank is not included, because his weight is blank. OpenOffice distinguishes between a cell that contains nothing and a cell that contains a formula that returns an empty string. 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.

Openoffice calc count non empty cells