Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 25 Apr 2013 22:19:40 +0200How to count TRUE entries in a columnhttps://ask.libreoffice.org/en/question/16615/how-to-count-true-entries-in-a-column/A spreadsheet has only the entries TRUE and FALSE.
<pre>
TRUE
TRUE
TRUE
TRUE
TRUE
FALSE</pre>
Which has been set up by entering TRUE in the top position an pulling it down into the rest of the column. To count the number of TRUE entries, which here is 5, the formula =COUNTIF(A1:A6,TRUE) applied to the column should work, but it always returns the result 1. On the other hand, the formula =COUNTIF(A1:A6,FALSE) works correctly on a similar column got by pulling down FALSE.
If a column is set up by actually entering the entries one after another, say
<pre>
TRUE
FALSE
FALSE
TRUE
TRUE</pre>
COUNTIF() works properly. I suspect that the problem is that LibreOffice is entering different **kinds** of TRUE, because when I apply Data->Filter->Standard_Filter to the first column (all TRUE), I see a large number of entries all TRUE.
What's going on? Is there any way to set up the column correctly? "Pulling down" TRUE() seems to have its own problems.JonryshThu, 25 Apr 2013 22:19:40 +0200https://ask.libreoffice.org/en/question/16615/