Reply To: [email protected]
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-6"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <[EMAIL PROTECTED]>
On Tuesday 17 October 2006 11:02 pm, Vanessa Cobern wrote:
> Hi, I am using Open Office.org Writer and I purchased it this year
> so I guess it is 2006 version.
>
> My problem is:
>
> I have created a table with figures in the columns and I need
> instructions on how to calculate the total for each column using
> the computer.
>
> Thank you!
=46rom another member of this mailing list:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you want an addition of all numbers, then the formula is:
=3DSUM(A1:A15), where A1:A15 is an example for the cell-range of the=20
column to
sum.
You type the formula on top or bottom of one of the columns and copy=20
it to
the following columns.
If you need the number of items instead of the sum, then the formula=20
would
be:
=3DCOUNT(A1:A3)
_________________________________________________________________________
Claudia
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
What she has written is true if you are using a spreadsheet=20
(Calc). However, if you have this table in a text document (Writer),=20
the formula is a little different:
=3Dsum(<A1:A15>).=20
It appears that the COUNT function does not work in Writer as it=20
does in Calc. In Writer, COUNT adds the cells rather than counts the=20
number of cells.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
