[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[O] calculate frequencies in a table with calc
From: |
Martin Gross |
Subject: |
[O] calculate frequencies in a table with calc |
Date: |
Tue, 25 Dec 2012 13:59:13 +0100 |
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(@address@hidden)::@6$1=vcount(map(<if(eq(#1,12),1,[])>,@address@hidden))
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
- [O] calculate frequencies in a table with calc,
Martin Gross <=