On Wednesday, October 18, 2006 10:41 AM [GMT+1=CET], Claudia Drechsle <[EMAIL
PROTECTED]> wrote:
> Hi Vanessa
>>
>>
>> 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.
>
>
> If you want an addition af all numbers, then the formula is:
> =SUM(A1:A15), where A1:A15 is an example for the cell-range of the
> column to sum.
> You type the formula on top or bottom of one of the columns and copy
> it to the following columns.
>
> If you need the number of items instead of the sum, then the formula
> would be:
> =COUNT(A1:A3)
>
I think the OP is using Writer. (From the original: "Hi, I am using Open
Office.org Writer and I purchased it this year so I guess it is 2006 version.")
If so then the formulae use "<" and ">" instead of "(" and ")". I have no idea
why.
Harold Fuchs
London, England
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
