# How to count TRUE entries in a column [closed]

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.

Same behavior here as with Horst. BTW: my version of LibreOffice is 3.6.6.2.

Mariosv has a workaround/solution. To see the source of the problem, format the entries in the first column as numeric, i.e. Format_Cell->Number->1234. Then the different kinds of TRUE become visible. This leads to the question: How to pull a constant down a column and not have it change to an increasing sequence of numbers.