On Thursday May 03 2007 6:36 am, Richard Detwiler wrote:
> Allan Murray wrote:
> > I have OO version 2.2. Newcomer. In Calc I wish to be able to add
> > together the sums of money in two or more cells, and place the
> > total sum in another cell. How do I do this? I used to be able to
> > do this in Lotus 1-2-3, but I am unable to do it in OO Calc so
> > far.
> >
> > Allan.
>
> To add together a block of cells, use the SUM function.
>
> Let's say the numbers you want to add are in cells A1 through A10,
> and you want the total of these numbers to be shown in A12.
>
> Go to A12, and type the following: =SUM(A1:A10) and press Enter.
> That's all there is to it.
To expand this a little bit farther, you can add columns of
numbers by also using the ; between columns: =SUM(A1:A10;C5:C20).
=SUM(A1:A10;C5:C20) will add cells A1 through A10 with cells C5
through C20.
You can even designate individual cells in a similar manner:
=SUM(A3;B1;D18;G35) will give you the sum of these four cells.
I have one spreadsheet in which I add several columns of numbers
and subtract from that the sum of some other columns.
Hope this helps rather than confuses you.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
