Dear helpers, on the web I found a formula to get frequencies which I modified to my needs, but it does not yet work well. An example:
|---------------------| | [1, 2, 3, 4, 5] | | [6, 7, 8] | | [9, 10, 11, 12, 12] | | 12, 12 | |---------------------| | 15 | | 2 | #+TBLFM: @5$1=vcount(@I..@II)::@6$1=vcount(map(<if(eq(#1,12),1,[])>,@I..@II)) With the first formula (@5$1) everything inside and outside the brackets is counted, but with the second (@6$1), where I am asking for the frequency of 12, only what is outside the brackets is considered. How could I also include what is inside the brackets, so I get 4? Thank you very much in advance! Martin