Hi Jarmo

On Sun, Aug 26, 2012 at 10:45 AM, Jarmo Hurri <jarmo.hu...@syk.fi> wrote:

> Does this help?

Yes.

>   but now it naturally gives an error, since the argument to
>   sum-row-prods is a list, not a list of lists (rows).

AFAIK there is no way to get the list of lists.

But if you didn’t already you may consider to separate the calculation
of rows and columns into two steps which I think should be possible in
most cases and use something like this:

| a | b | prod |
|---+---+------|
| 2 | 3 |    6 |
| 4 | 5 |   20 |
|   |   |   26 |
#+TBLFM: $3 = '(* $1..$2); N :: @>$3 = '(+ @2..@3); N

or with Calc formulas:

#+TBLFM: $3 = vprod($1..$2) :: @>$3 = vsum(@2..@3)

Michael

Reply via email to