Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 12 Dec 2014 21:55:46 +0100Counting number of times two adjacent cells match a certain criteriahttps://ask.libreoffice.org/en/question/43574/counting-number-of-times-two-adjacent-cells-match-a-certain-criteria/Hello, I'm looking for a way to count the number of times two adjacent cells in two separate columns match. In this example, column A contains vehicle types ("SUV", "Sedan", "Truck"), and in column B contains vehicle color ("Red", "Blue", "Black").
I want to count the number of black SUVs:
A B
1 SUV Red
2 Truck Blue
3 Sedan Red
4 SUV Black
5 Sedan Blue
6 Truck Blue
7 SUV Black
In this case, the function should print 2.
Is there a way to do this?MrMusAddictFri, 12 Dec 2014 21:55:46 +0100https://ask.libreoffice.org/en/question/43574/How 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/