A spreadsheet has only the entries TRUE and FALSE.
TRUE TRUE TRUE TRUE TRUE FALSE
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
TRUE FALSE FALSE TRUE TRUE
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.