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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
