Thanks for the helpful replies to question 2 but what about question 1? Any
thoughts on how I can get org-mode to dynamically add an extra row?
Thanks,
-Emin
On Tue, Sep 7, 2010 at 5:20 AM, Christian Moe wrote:
> On 9/7/10 2:56 AM, Juan wrote:
>
>> A very complex way of not adding the extra col
On 9/7/10 2:56 AM, Juan wrote:
A very complex way of not adding the extra column:
| name | a | b | c |
|--++---+---|
| foo | 1 | 2 | 3 |
| bar | 3 | 2 | 1 |
| bar | 4 | 5 | 6 |
|--++---+---|
| | 7 | | |
#+TBLFM: @5$2='(apply '+ (mapcar* (lambda(x y) (if (string=
A very complex way of not adding the extra column:
| name | a | b | c |
|--++---+---|
| foo | 1 | 2 | 3 |
| bar | 3 | 2 | 1 |
| bar | 4 | 5 | 6 |
|--++---+---|
| | 7 | | |
#+TBLFM: @5$2='(apply '+ (mapcar* (lambda(x y) (if (string= x "bar") y 0))
'(@i$...@ii$1) '(
On 9/6/10 3:38 PM, Inquisitive Scientist wrote:
2. How do I compute the sum of a column only if a corresponding row
matches some condition? For example, how do I compute the sum of
numbers in column a for which the name in column "name" is "bar"? For
example, I should get 7 for the sum in col
