* org table spreadsheet problem
@ 2011-11-28 7:32 qkbeyond
2011-11-28 16:55 ` Juan Pechiar
0 siblings, 1 reply; 2+ messages in thread
From: qkbeyond @ 2011-11-28 7:32 UTC (permalink / raw)
To: emacs-orgmode
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.
^ permalink raw reply [flat|nested] 2+ messages in thread
* Re: org table spreadsheet problem
2011-11-28 7:32 org table spreadsheet problem qkbeyond
@ 2011-11-28 16:55 ` Juan Pechiar
0 siblings, 0 replies; 2+ messages in thread
From: Juan Pechiar @ 2011-11-28 16:55 UTC (permalink / raw)
To: qkbeyond; +Cc: emacs-orgmode
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, qkbeyond@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.
^ permalink raw reply [flat|nested] 2+ messages in thread
end of thread, other threads:[~2011-11-28 16:55 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2011-11-28 7:32 org table spreadsheet problem qkbeyond
2011-11-28 16:55 ` Juan Pechiar
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).