From mboxrd@z Thu Jan  1 00:00:00 1970
From: Martin Gross <m-gross@gmx.net>
Subject: calculate frequencies in a table with calc
Date: Tue, 25 Dec 2012 13:59:13 +0100
Message-ID: <CAJkULmn6Xw9dqS7huWoQPESCLOh3PavF=WnCWfbsaU7RoeugGQ@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:40207)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <grossberreiter@gmail.com>) id 1TnU6P-0001dz-ER
	for emacs-orgmode@gnu.org; Tue, 25 Dec 2012 07:59:31 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <grossberreiter@gmail.com>) id 1TnU6G-0006RC-CK
	for emacs-orgmode@gnu.org; Tue, 25 Dec 2012 07:59:25 -0500
Received: from mail-ea0-f178.google.com ([209.85.215.178]:55476)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <grossberreiter@gmail.com>) id 1TnU6G-0006Qv-5t
	for emacs-orgmode@gnu.org; Tue, 25 Dec 2012 07:59:16 -0500
Received: by mail-ea0-f178.google.com with SMTP id k11so3252930eaa.37
	for <emacs-orgmode@gnu.org>; Tue, 25 Dec 2012 04:59:14 -0800 (PST)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

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