Hi Cecil.

The attached email from orgmode mailing list includes code for a
conditional vsum, which is what you need here.

Regards,
.j.

On Mon, Nov 15, 2010 at 01:10:52PM +0100, Cecil Westerhof wrote:
> It is just a table with activities and the needed time pro activity.
> When there is an asterisk in the first column, that means that the
> activity is already done. I would like a little more fancy table that
> also displays the time needed for the activities that still have to be
> done. Like the following:
> |---+----------+-----------|
> |   | activity | time      |
> |---+----------+-----------|
> | * | A        | 0@ 10'    |
> | * | B        | 0@ 05'    |
> |   | C        | 0@ 05'    |
> |   | D        | 0@ 05'    |
> |   | E        | 0@ 05'    |
> |---+----------+-----------|
> | # | Totaal   | 0.50      |
> | ^ |          | totalTime |
> | # | Totaal   | 0.25      |
> | ^ |          | restTime  |
> |---+----------+-----------|
> #+TBLFM: $totalTime = deg(vsum(@-II..@-I)); f2
>
> Is this possible? If yes, how would I do this?
>