From mboxrd@z Thu Jan  1 00:00:00 1970
From: Nathan Neff <nathan.neff@gmail.com>
Subject: Basic Question: Effort Sum
Date: Wed, 8 Dec 2010 18:02:52 -0600
Message-ID: <AANLkTinH5rtuhjSTH3yEymoUnALGXULPVasy0BZq2g2w@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from [140.186.70.92] (port=47612 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1PQTyK-0003ZW-0K
	for emacs-orgmode@gnu.org; Wed, 08 Dec 2010 19:02:57 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <nathan.neff@gmail.com>) id 1PQTyI-0005NS-TN
	for emacs-orgmode@gnu.org; Wed, 08 Dec 2010 19:02:55 -0500
Received: from mail-bw0-f43.google.com ([209.85.214.43]:38456)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <nathan.neff@gmail.com>) id 1PQTyI-0005Mf-OK
	for emacs-orgmode@gnu.org; Wed, 08 Dec 2010 19:02:54 -0500
Received: by bwz14 with SMTP id 14so1989973bwz.30
	for <emacs-orgmode@gnu.org>; Wed, 08 Dec 2010 16:02:53 -0800 (PST)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/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: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode <emacs-orgmode@gnu.org>

Hello,

I have a dynamic table that gives me a list of the items in a file
and their effort estimates.  I'd like to either
1) Have org-mode sum the effort for me, much like the CLOCKSUM feature
or
2) Write a simple calc function and manually put it into the table to sum
the first column which contains the effort estimates.

Here's a sample file:
#+COLUMNS: %08Effort(Est.){+} %40ITEM(Task) %7CLOCKSUM(Clocked)
* Effort Summary Table
#+BEGIN: columnview :hlines 1 :id global
#+END:
* Task 1
:PROPERTIES:
:Effort: 4:00
:END:
* Task 2
:PROPERTIES:
:Effort: 3:00
:END:

I can't seem to find the correct syntax for the range of an entire column.
I've tried using something like this:
#+TBLFM: @2$3=vsum(@4$1..@3$1)

But I haven't been able to sum the entire column.  Can anyone help?

Thanks,
--Nate