Steve,
Thanks for your response. As you may have already seen from my response
to Brian's reply, the solution to my problem is to use F2 rather than
the sum icon from the toolbar. This produces and allows the formula
=sum to be used and stick. The sum icon seems to convert such a
formula to
On 07/14/2017 03:34 AM, Brian Barker wrote:
Aha! I wasn't using the Sum icon, and it does indeed lead to a formula
listing the cells in the range individually - instead of as a range. I
don't see why this should be. This indeed makes subsequent dragging
problematic. And I now see where
At 17:38 13/07/2017 -0700, Girvin Herr wrote:
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,
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
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
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. |)
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,
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
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