emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed

From: Stefan Nobis <stefan-ml@snobis.de>
To: emacs-orgmode@gnu.org
Subject: Sum marked values in table
Date: Fri, 22 Mar 2013 11:19:14 +0100	[thread overview]
Message-ID: <m1620jybx9.fsf@nobis-it.eu> (raw)

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.

next             reply	other threads:[~2013-03-22 10:19 UTC|newest]

Thread overview: 2+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2013-03-22 10:19 Stefan Nobis [this message]
2013-03-23  9:42 ` Sum marked values in table Michael Brand

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=m1620jybx9.fsf@nobis-it.eu \
    --to=stefan-ml@snobis.de \
    --cc=emacs-orgmode@gnu.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).