You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Michael Warvill <mi...@btinternet.com> on 2017/03/17 11:20:41 UTC
Spreadsheet
Please can you tell me how to set up a calculation to enable me to: example total all of column C
Rows 1 to 29 into row 30? Without using 1+2+3. Can't find answer anywhere.
Thank you
Mike W
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
RE: Spreadsheet
Posted by Simona Negrea <si...@hotmail.com>.
You type in cell C30 the following
=sum(c1:c29)
Sent from my Samsung Galaxy S6 smartphone.
-------- Original message --------
From: Michael Warvill <mi...@btinternet.com>
Date: 3/17/17 13:33 (GMT+02:00)
To: users@openoffice.apache.org
Subject: Spreadsheet
Please can you tell me how to set up a calculation to enable me to: example total all of column C
Rows 1 to 29 into row 30? Without using 1+2+3. Can't find answer anywhere.
Thank you
Mike W
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Spreadsheet
Posted by Martin Groenescheij <Ma...@Groenescheij.COM>.
On 17/03/17 10:20 PM, Michael Warvill wrote:
> Please can you tell me how to set up a calculation to enable me to: example total all of column C
> Rows 1 to 29 into row 30? Without using 1+2+3. Can't find answer anywhere.
SUM(C1:C29)
> Thank you
> Mike W
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org