I have some org-mode tables like this:

#+NAME: TableA
| Task | Amount |
| Gna  |      1 |

#+NAME: TableB
| Task   | Amount |
| Gnampf |      3 |

| Overall | Amount |
|         |      4 |
|         |      3 |
#+TBLFM: @2$2=remote(TableA, @I$>)+remote(TableB, @I$>)::@3$2=vsum(remote(TableA, @I$>) remote(TableB, @I$>))

Using + to sum up the amounts in remote TableA and TableB works, but vsum doesn't. Why?

Bonus: If I have several of these tables, is there a way to iterate over all of them instead of enumerating them manually?

  • The argument or vsum have to be a vector, so [remote(TableA, @I$>), remote([TableB, @I$>)] instead of remote(TableA, @I$>), remote(TableB, @I$>).
    – gigiair
    Commented Apr 5, 2022 at 13:33
  • @gigiair: I think that's correct. Can you make it into a proper answer?
    – NickD
    Commented Apr 5, 2022 at 14:04

1 Answer 1


The argument of vsum has to be a vector, so use vsum([remote(TableA, @I$>), remote([TableB, @I$>)]) instead of vsum(remote(TableA, @I$>), remote(TableB, @I$>)).


From your Org document, you can evaluate this code block:

#+BEGIN_SRC emacs-lisp :var basename="Table" start= (eval ?A) stop= (eval ?B)
     (format "Summary of tables from Table%c to Table%c" start stop) (format ":=%s"(mapconcat (lambda(x)(format "remote(Table%c,@>$2)" x))(number-sequence start stop) "+"))))

which returns

| Summary of tables from TableA to TableB | :=remote(TableA,@>$2)+remote(TableB,@>$2) |

and evaluate it with Ctrl-c Ctrl-c

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.