From mboxrd@z Thu Jan  1 00:00:00 1970
From: Uwe Brauer <oub@mat.ucm.es>
Subject: problem with lookup, count several string in one (or more) columns.
Date: Mon, 04 Jul 2016 19:57:39 +0000
Message-ID: <877fd1b2h8.fsf@mat.ucm.es>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:46916)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1bKA0A-0003PM-5s
	for emacs-orgmode@gnu.org; Mon, 04 Jul 2016 15:57:55 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1bKA06-0001k4-2Q
	for emacs-orgmode@gnu.org; Mon, 04 Jul 2016 15:57:53 -0400
Received: from plane.gmane.org ([80.91.229.3]:52027)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1bKA05-0001k0-Rx
	for emacs-orgmode@gnu.org; Mon, 04 Jul 2016 15:57:50 -0400
Received: from list by plane.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1bKA04-000082-KP
	for emacs-orgmode@gnu.org; Mon, 04 Jul 2016 21:57:48 +0200
Received: from 229.red-88-22-82.staticip.rima-tde.net ([88.22.82.229])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Mon, 04 Jul 2016 21:57:48 +0200
Received: from oub by 229.red-88-22-82.staticip.rima-tde.net with local
	(Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Mon, 04 Jul 2016 21:57:48 +0200
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"
	<emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
To: emacs-orgmode@gnu.org



Hello

I tried to follow the instructions found in
http://orgmode.org/worg/org-tutorials/org-lookups.html

So I want to count all strings NP MH  in the following table
According to the instructions, the following will search the string MH.

| group | round 1 | round 2 |
|-------+---------+---------|
| A     |         |     2.4 |
| B     | 4.7     |      11 |
| C     |         |      MH |
| D     | 5       |         |
| E     |         |     7.2 |
| F     | 3.2     |     4.3 |
| G     | NP      |     4.4 |
| H     | NP      |       8 |
| I     | NP      |       8 |
|-------+---------+---------|
| total | MH      |       1 |
#+TBLFM: @>$3='(length(org-lookup-all "MH" '(@2$2..@-1$3) nil));

So I could repeat that for the string NP as well but how can I search
for both (or more) strings at once?