Understanding Lists in an Open Office Spreadsheet

Question

List Comprehension is a very useful code engine that can be found in several languages ​​such as Haskell, Python, and Ruby (just to name a few of them on my head). I am familiar with the design.

I am working on an Open Office table and I need to do something fairly common: I want to calculate all the values ​​in a range of cells that fall between high and low borders. I immediately thought that understanding this list would do the trick, but I can't find anything like it in Open Office. There is a feature called "COUNTIF", and it's something similar, but not quite what I need.

Is there a constructor in Open Office that can be used to comprehend the list?

Answer 1

CountIf can count values ​​equal to one selected. Unfortunately, it seems that there is no good candidate for such a function. Alternatively, you can use an additional column with If to display 1 or 0 if the value matches the range or not, respectively:

=If(AND({list_cell}>=MinVal; {list_cell}<=MaxVal); 1; 0)

Then it remains only to add the next column.