Permanently summing a column in an Org-mode table

emacs org-mode org-table
Mauvis Ledford picture Mauvis Ledford · Jul 14, 2011 · Viewed 31.3k times · Source

In an Emacs Org-mode table, when you have a column full of integers I know you can do C-c + followed by C-y to paste the sum of the values in the column. I want to know the formula to place in the last row to always sum the whole column.

I've tried everything. The docs show you how to sum two columns together but not one.

Answer

huaiyuan picture huaiyuan · Jul 14, 2011

Assign a field-name using the ^ mark:

|---+---|
|   | 1 |
|   | 2 |
|   | 3 |
|---+---|
|   | 6 |
| ^ | x |
|---+---|
#+TBLFM: $x=vsum(@1..@-1)

See The Org Manual, Section-3.5.9 Advanced Features.

Related questions

Compare markdown or org mode

I use Emacs for years, and nowadays, I write a lot of files in org mode, such as notes, plans/conclusions or something else. However but most website support markdown-style instead of org-style. StackOverflow is an example. :) Can someone tell …

Read More
How to make all org-files under a folder added in agenda-list automatically?

I am using org-mode to write notes and org-agenda to organize all notes, especially to search some info. by keyword or tag. C-c a m can search some files by tag inputed, C-c a s by keyword ,those functions from …

Read More
Emacs org-display-inline-images

How can I display inline images in emacs org mode? I have [[file:~/myimage.png]], which, when clicked, opens the image in a new buffer. But how to do it in the same buffer? Note: C c C x C …

Read More