Hi list,

Formulas reference in a long table are very easy corrupted by manually
inserting. so, I think, refer using name instead of num. is better.

but how to refer the rows by name?

For example,

|---+------+---------+--------+---------+------|
| ! | date | amount  | item   | account | note |
|   | date | amount  | item   | account | note |
|---+------+---------+--------+---------+------|
| _ |      | bamount |        |         |      |
|   |      | 12      | lunch  | pocket  |      |
|   |      | 59      | dinner | pocket  |      |
| ^ |      | eamount |        |         |      |
|---+------+---------+--------+---------+------|
| _ |      | total   |        |         |      |
| # |      | #ERROR  |        |         |      |
|---+------+---------+--------+---------+------|
#+TBLFM: $total=vsum($bamount..$eamount);%.2f

I'd expected $bamount..$eamount is the range of @II$amount..@III$amount, but
it's not. $bamount and $eamount are epxanded to the values too early.




                                                      Changsheng Jiang