Dear Experts, I am becoming very fond of the table/spreadsheet in org-mode and trying to use it more extensively. I have tried digging through the docs but am still having trouble with some things:
1. Is there a way to dynamically add a new row to a table using a table formula? For example, a variety of org-mode things will produce a table as output and allow me to specify some formulas. I'd like to add a formula that says something like "create a row at the bottom that sums column 3" and have that be a new row that gets added. Any thoughts? 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 column a in the table below: | name | a | b | c | |------+---+---+---| | foo | 1 | 2 | 3 | | bar | 3 | 2 | 1 | | bar | 4 | 5 | 6 | |------+---+---+---| Thanks, -I.S.
_______________________________________________ Emacs-orgmode mailing list Please use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode
