From mboxrd@z Thu Jan  1 00:00:00 1970
From: Christian Moe <mail@christianmoe.com>
Subject: Re: Fwd: Re: Adding items in table
Date: Thu, 02 Oct 2014 11:59:07 +0200
Message-ID: <m2ppeassgk.fsf@christianmoe.com>
References: <CAFrmxDc9XW5s4_AKvF0bYAZhzgJaYCH+dGdqncpomnBG=Cy-4g@mail.gmail.com>
	<m2vbo2svin.fsf@christianmoe.com> <m2tx3msv5m.fsf@christianmoe.com>
	<CAFrmxDc=7+xFiGsizNTpmYsyXYCtZviHH-vWyf8MdhmtQuWY5g@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:34085)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <mail@christianmoe.com>) id 1XZd9c-0004n9-V3
	for emacs-orgmode@gnu.org; Thu, 02 Oct 2014 05:58:39 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <mail@christianmoe.com>) id 1XZd9W-0005Ik-Ng
	for emacs-orgmode@gnu.org; Thu, 02 Oct 2014 05:58:32 -0400
Received: from mail2.b1.hitrost.net ([91.185.211.205]:35869)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <mail@christianmoe.com>) id 1XZd9W-0005E7-Hm
	for emacs-orgmode@gnu.org; Thu, 02 Oct 2014 05:58:26 -0400
In-reply-to: <CAFrmxDc=7+xFiGsizNTpmYsyXYCtZviHH-vWyf8MdhmtQuWY5g@mail.gmail.com>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Chris Henderson <henders254@gmail.com>
Cc: "emacs-orgmode@gnu.org" <emacs-orgmode@gnu.org>


It looks like what you actually want to do is add up the numbers in the
rows of column 3 -- from row 2 to 3 in your example. Your original
formula added up columns (prefixed with `$'). Rows are prefixed with `@'.

You need to get rid of the dollar signs in your cells to let Org know
they contain numbers.

This would work:

| Item  | Model | price ($) |
| x     | v     |    323.98 |
| y     | x     |    184.45 |
| Total |       |    508.43 |
#+TBLFM: @4$3=vsum(@2..@3)

I usually prefer to add horizontal lines and make the formula relative
to them:

| Item  | Model | price ($) |
|-------+-------+-----------|
| x     | v     |    323.98 |
| y     | x     |    184.45 |
|-------+-------+-----------|
| Total |       |    508.43 |
#+TBLFM: @4$3=vsum(@I..@II)

Hope this helps,

Christian


Chris Henderson writes:

> Here's an example of the table (hope the line breaks are ok)
>
> |Item | Model | price |
> | x     | v          | $323.98
> | y     | x          | $184.45|
> | Total |           | ??          |
>
> On Thu, Oct 2, 2014 at 7:01 PM, Christian Moe <mail@christianmoe.com> wrote:
>
>>
>> Christian Moe writes:
>>
>> You probably don't really want to replace the contents of column 3 ($3)
>> with a sum of columns including column 3 ($2..$9)?
>>
>> To get useful help you'll need to provide the table, or a minimal
>> example of a table with the same structure.
>>
>> Yours,
>> Christian
>>
>> >
>> > Chris Henderson writes:
>> >
>> >> I have a table and would like to add all costs (in $) in column 3 as a
>> >> total. Wondering how do I do that. I have done "=vsum($2..$9)" - but
>> this
>> >> hangs my org file and I have to kill it with the -9 switch.
>> >>
>> >> Thanks.
>>
>>
>>