If you don't want the column K to show zeroes when nothing is entered in the corresponding I and J cells,
instead of entering =I1*J1, enter something like =IF(OR(I1="";J1="");"";I1*J1)
That will make the Kcolum cells to look empty until values have been entered in
the corresponding I and J cells.
After that, do as Dennis said...
Johnny
Den 2006-01-10 19:37:48 skrev Dennis Marks <[EMAIL PROTECTED]>:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
