Enter the formula in cell K1 cell (=I1*J1). Select cell K1 and you will notice a little box appear at the bottom right of the box. Click on the box and you will see a little +. Drag it down the column as far as you want and the cells will be copied. In the next column K box enter =sum( and then click the first box (K1) and drag down to just above the sum box. Enter a ) and that's it.
"Jon Jahren" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi. > > I have installed OpenOffice.org2 for a friend of mine, and he's going to > use it for simple spreadsheet tasks. > Right now, we have figured most of it out. However, there is one thing i > cannot find for my life of it; > He's got a row I and J, which holds Price and amount, and K holds the > sum of those. > This is all nice and dandy, however, he wants to be able to fill in the > values in I and J downwards, and then have K automatically calculate I*J > and then have the next cell in K hold the sum of all K cells above. How > do I accomplish this task? Just a little nudge in the right direction > please, because I'm not really a spreadsheet guru. Maybe some sort of > script? Any tutorials? > Thanks in advance > Jon --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
