Hi list,<div><br></div><div>Formulas reference in a long table are very easy corrupted by manually inserting. so, I think, refer using name instead of num. is better.</div><div><br></div><div>but how to refer the rows by name?</div>

<div><br></div><div>For example,</div><div><br></div><div><div>|---+------+---------+--------+---------+------|</div><div>| ! | date | amount  | item   | account | note |</div><div>|   | date | amount  | item   | account | note |</div>

<div>|---+------+---------+--------+---------+------|</div><div>| _ |      | bamount |        |         |      |</div><div>|   |      | 12      | lunch  | pocket  |      |</div><div>|   |      | 59      | dinner | pocket  |      |</div>

<div>| ^ |      | eamount |        |         |      |</div><div>|---+------+---------+--------+---------+------|</div><div>| _ |      | total   |        |         |      |</div><div>| # |      | #ERROR  |        |         |      |</div>

<div>|---+------+---------+--------+---------+------|</div><div>#+TBLFM: $total=vsum($bamount..$eamount);%.2f</div></div><div><br></div><div>I&#39;d expected $bamount..$eamount is the range of @II$amount..@III$amount, but it&#39;s not. $bamount and $eamount are epxanded to the values too early.</div>

<div><br></div><div><br></div><div><br></div><div><br clear="all">                                                      Changsheng Jiang<br>
</div>