[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] org table spreadsheet problem
From: |
Juan Pechiar |
Subject: |
Re: [O] org table spreadsheet problem |
Date: |
Mon, 28 Nov 2011 14:55:37 -0200 |
User-agent: |
Mutt/1.5.20 (2009-06-14) |
Hi,
Please check the following thread on a similar problem:
http://thread.gmane.org/gmane.emacs.orgmode/29877/focus=29920
There is a definition for 'vsumif' function you can use to add
conditionally.
Regards,
.j.
On Mon, Nov 28, 2011 at 03:32:05PM +0800, address@hidden wrote:
> hi,all.
> I have a orgtbl like the following,
>
> | # | 2 | a |
> | # | -2 | abc |
> | # | 5 | abc |
> | # | -3 | a |
> |---+----+-----|
> | | | |
> | ^ | x | |
>
> and i want to sum the second column which the corresponding third
> column's values="abc" to variable x. (in this example $x = -2+5 = 3).
> what Formula syntax for Calc/Lisp can achieve this,please. thanks.