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, qkbey...@gmail.com 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.
