From mboxrd@z Thu Jan  1 00:00:00 1970
From: Stefan Nobis <stefan-ml@snobis.de>
Subject: Sum marked values in table
Date: Fri, 22 Mar 2013 11:19:14 +0100
Message-ID: <m1620jybx9.fsf@nobis-it.eu>
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 ([208.118.235.92]:45181)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <stefan-ml@snobis.de>) id 1UIz4H-0000yN-7Z
	for emacs-orgmode@gnu.org; Fri, 22 Mar 2013 06:19:29 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <stefan-ml@snobis.de>) id 1UIz4G-0002rM-2P
	for emacs-orgmode@gnu.org; Fri, 22 Mar 2013 06:19:25 -0400
Received: from basilikum.nobis-admin.de ([89.238.71.130]:59739)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <stefan-ml@snobis.de>) id 1UIz4F-0002q3-SB
	for emacs-orgmode@gnu.org; Fri, 22 Mar 2013 06:19:23 -0400
Received: from localhost (localhost.localdomain [127.0.0.1])
	by basilikum.nobis-admin.de (Postfix) with ESMTP id 644A655A76
	for <emacs-orgmode@gnu.org>; Fri, 22 Mar 2013 11:19:21 +0100 (CET)
Received: from basilikum.nobis-admin.de ([127.0.0.1])
	by localhost (basilikum.nobis-admin.de [127.0.0.1]) (amavisd-new,
	port 10024) with ESMTP id Vai7QTLoOQk2 for <emacs-orgmode@gnu.org>;
	Fri, 22 Mar 2013 11:19:15 +0100 (CET)
Received: from karotte.salat.nobis-admin.de (d185092.adsl.hansenet.de
	[80.171.185.92]) by basilikum.nobis-admin.de (Postfix) with ESMTPSA
	for <emacs-orgmode@gnu.org>; Fri, 22 Mar 2013 11:19:15 +0100 (CET)
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

Hi.

Is there any way to somehow mark cells in an org-table and then sum
over all marked cells of the whole table. For example in the following
table I marked some time values bold:

  |        | Col 1 | Col 2  | Col 3  | Col4 |      Sum |
  |--------+-------+--------+--------+------+----------|
  | Row 1  |       | *1:00* |        |      | 01:00:00 |
  | Row 2  |  8:30 | 6:30   | *7:00* |      | 22:00:00 |
  |--------+-------+--------+--------+------+----------|
  | Sum    |       |        |        |      | 23:00:00 |
  | Marked |       |        |        |      | 08:00:00 |
  #+TBLFM: @>$>=??????::@>>$>=vsum(@<<..@>>>);T::$>=vsum($<<..$>>);T

Exist some clever trick to be used as formula for @>$> or is a custom
lisp function needed for this?

-- 
Until the next mail...,
Stefan.