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