Adding items in table

Adding items in table

[Chris Henderson]

[-- Attachment #1: Type: text/plain, Size: 214 bytes --]

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.

[-- Attachment #2: Type: text/html, Size: 267 bytes --]

Re: Adding items in table

[Christian Moe]

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.

Fwd: Re: Adding items in table

[Christian Moe]

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.

Re: Fwd: Re: Adding items in table

[Chris Henderson]

[-- Attachment #1: Type: text/plain, Size: 842 bytes --]

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.
>
>
>

[-- Attachment #2: Type: text/html, Size: 1425 bytes --]

Re: Fwd: Re: Adding items in table

[Christian Moe]

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.
>>
>>
>>