From mboxrd@z Thu Jan  1 00:00:00 1970
From: Martin Gross <m-gross@gmx.net>
Subject: sum up variables from different org-mode tables
Date: Fri, 16 Nov 2012 12:33:24 +0100
Message-ID: <CAJkULmktbtUYOnZbhf_VLbhHoh8fiJca_6uOFK2qr7nDT0O+8Q@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:47420)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <grossberreiter@gmail.com>) id 1TZKAr-0007tp-5T
	for emacs-orgmode@gnu.org; Fri, 16 Nov 2012 06:33:32 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <grossberreiter@gmail.com>) id 1TZKAo-0005c7-3P
	for emacs-orgmode@gnu.org; Fri, 16 Nov 2012 06:33:29 -0500
Received: from mail-ee0-f41.google.com ([74.125.83.41]:46154)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <grossberreiter@gmail.com>) id 1TZKAn-0005br-TJ
	for emacs-orgmode@gnu.org; Fri, 16 Nov 2012 06:33:26 -0500
Received: by mail-ee0-f41.google.com with SMTP id d41so1830097eek.0
	for <emacs-orgmode@gnu.org>; Fri, 16 Nov 2012 03:33:24 -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,

I have a big file where I enter incomings and outgoings of book
exchanges with different institutions:

* Institution A
  |   | In      |  # |   =E2=82=AC | Out     |  # |   =E2=82=AC |
  |---+---------+----+-----+---------+----+-----|
  |   | Title P |  1 |  45 | Title A |  1 |  15 |
  |   |         |    |     | Title B |  2 |  28 |
  |---+---------+----+-----+---------+----+-----|
  | # |         |  1 |  45 |         |  3 |  43 |
  | ^ |         | TE | TEE |         | TA | TAE |
  #+TBLFM: $TE=3Dvsum(@I..@II)::$TEE=3Dvsum(@I..@II)::$TA=3Dvsum(@I..@II)::=
$TAE=3Dvsum(@I..@II)

* Institution B
  |   | In | #  |  =E2=82=AC   | Out | #   | =E2=82=AC   |
  ...
  | # |    |  1 |  24  |     |  2  | 31  |
  | ^ |    | TE | TEE  |     | TA  | TAE |

Now I would like to get some statistics that consider all institutions
together.  For example summing up the "variable" TAE from all the
tables in the file to get the very total cost of outgoings.

Is something like that possible?

Thank you very much in advance!

Martin