Givin, Have you tried a "," or a ";" instead of a ":" ?
Sent from my iPhone > On Jul 13, 2017, at 3:11 PM, Girvin Herr <ghe...@fastmail.com> wrote: > > Greetings, > > I have a Writer document with about 50 rows in a table. At the bottom of the > table, I want to sum the above column of cells in each row (a total). > Currently, the only way to add a new row or rows to this sum is to add the > cell reference(s) (i.e. |<J47>) to the long string of cell references to sum. > Is this the only way, other than dragging from the first cell to the last > cell? > > I tried =sum(J2:Jn) and even =sum(<J2>:<Jn>) but that just displays a formula > error message in the sum cell. > > I would like to be able to add rows to this table as needed and have an easy > way to add the new cells to the sum. A way of specifying a range of cells is > perfect. As I now do it, the more rows I need to add, the more tedious and > error-prone this process becomes. > > Thanks. > > Girvin Herr > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
