Brian Barker wrote:
At 17:19 26/08/2007 -0500, Bill Eyesaw wrote:
I am trying to determine how to enter into an Open Office document
simple formulas to calculate addition totals for individual column
ranges. Any help appreciated -
Are we talking of an OpenOffice *spreadsheet* (i.e. Calc) document?
o Click in the cell where you want the column total.
o Click on the capital-sigma symbol in the input line above the sheet
display. (Greek sigma means "sum" in mathematics.)
o A blue box appears around a suggested range to be summed. If
necessary, grasp it by the hand symbol inside the box and drag the box
until the top left corner is in the appropriate place.
o Now grasp the tiny blue square at the bottom right of the box and
drag this, too, until it is in the appropriate place. The blue box
now indicates the range you want summed.
o Press the green tick symbol in the input line to approve what you
have done.
o Bingo!
Look in the input line. You will see a formula using the SUM
function. See how it works. You can type such formulae in the input
line or edit them there yourself if you prefer.
I trust this helps.
Brian Barker
On the other hand, if you're talking about a table in Writer, it can be
done there, too. If you click in the cell where you want the sum and
type =, a formula bar will appear near the top of the window. One of the
buttons is labeled with something that looks like a fancy f(x). Click
and drag down from that; it will show a list of available functions, the
first of which is SUM. When the cursor is there, drop it. Now click and
drag across the range of table cells you want to add. When they're all
selected, drop. You should now have something showing in the formula bar
and in the table cell that looks something like =sum<A1:A5> (in this
case, summing the first five cells of the first column of the table).
Press Enter, and the formula will be replaced in the table by the
calculated sum.
The formulas themselves work just like what Brian was describing for
Calc. You can type all kinds of them directly into the formula bar, if
you have something more complicated than a simple range. For instance,
you can start with the = in your result cell, click a cell, type +,
click another cell, and so on until all the things you want to add are
in the formula, then Press Enter and the sum will be calculated. A
surprising amount of power here, isn't there?
(cc to Bill Eyesaw)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
