Girvin (sorry about the misspelling), What formula do you get when you click and drag? That should give you the correct format that you can follow for other columns or in a spread sheet you can "copy" the result cell and "paste special" to other columns' result cells.
Sent from my iPhone > On Jul 13, 2017, at 4:14 PM, Girvin Herr <ghe...@fastmail.com> wrote: > > Steven, > > I just tried both, and with and without the <> and got the same results: > **Expression is faulty **. > > Thanks for the help. > Girvin > > > >> On 07/13/2017 03:47 PM, Steven Ahlers wrote: >> 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 >> > > > --------------------------------------------------------------------- > 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
