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<B1:B50> to be used and stick. The sum icon seems to convert such a
formula to the long form of =sum(<B1>|<B2>|...|<B50>), which is tedious
and error-prone to edit and change.
Thanks again.
Girvin
On 07/13/2017 05:02 PM, Steve Ahlers wrote:
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
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
