From mboxrd@z Thu Jan 1 00:00:00 1970 From: Chris Henderson Subject: Re: Fwd: Re: Adding items in table Date: Thu, 2 Oct 2014 19:42:44 +1000 Message-ID: References: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=90e6ba47638b42c4ab05046d7087 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:59617) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XZcuM-000838-Td for emacs-orgmode@gnu.org; Thu, 02 Oct 2014 05:42:47 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1XZcuL-0007H5-Li for emacs-orgmode@gnu.org; Thu, 02 Oct 2014 05:42:46 -0400 Received: from mail-vc0-x234.google.com ([2607:f8b0:400c:c03::234]:59683) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XZcuL-0007Gv-Fm for emacs-orgmode@gnu.org; Thu, 02 Oct 2014 05:42:45 -0400 Received: by mail-vc0-f180.google.com with SMTP id le20so1118192vcb.39 for ; Thu, 02 Oct 2014 02:42:45 -0700 (PDT) In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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: Christian Moe Cc: "emacs-orgmode@gnu.org" --90e6ba47638b42c4ab05046d7087 Content-Type: text/plain; charset=UTF-8 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 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. > > > --90e6ba47638b42c4ab05046d7087 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Here's an example of the table (ho= pe the line breaks are ok)

|Item | Model | price |
|= x=C2=A0=C2=A0=C2=A0=C2=A0 | v=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0 | $323.98
| y=C2=A0=C2=A0=C2=A0=C2=A0 | x=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | $184.45|
| Total |=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | ??=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |

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 "=3Dvsum($2..$= 9)" - but this
>> hangs my org file and I have to kill it with the -9 switch.
>>
>> Thanks.



--90e6ba47638b42c4ab05046d7087--