[O] how to refer row's by name in a spreadsheet formula?

[address@hidden]

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 @address@hidden, but it's not. $bamount and $eamount are epxanded to the values too early.

                                                      Changsheng Jiang