Re: Is there a way to simplify summing Writer table cells?

2017-07-13 Thread Steve Ahlers
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

Re: Is there a way to simplify summing Writer table cells?

2017-07-13 Thread Girvin Herr
On 07/13/2017 04:58 PM, Brian Barker wrote: At 15:11 13/07/2017 -0700, Girvin Herr wrote: 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

Re: Is there a way to simplify summing Writer table cells?

2017-07-13 Thread Brian Barker
At 15:11 13/07/2017 -0700, Girvin Herr wrote: 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. |)

Re: Is there a way to simplify summing Writer table cells?

2017-07-13 Thread Girvin Herr
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,

Re: Is there a way to simplify summing Writer table cells?

2017-07-13 Thread Steven Ahlers
Givin, Have you tried a "," or a ";" instead of a ":" ? Sent from my iPhone > On Jul 13, 2017, at 3:11 PM, Girvin Herr 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)

Is there a way to simplify summing Writer table cells?

2017-07-13 Thread Girvin Herr
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. |) to the long string of cell refere