-----Original Message----- >From: Dan Lewis <[EMAIL PROTECTED]> >Sent: Oct 23, 2006 12:21 PM >To: [email protected] >Subject: Re: [users] Calc, _easily_ summing sparsely populated columns? > > >On Monday 23 October 2006 02:12 pm, Kirill S. Palagin wrote: >> Hello. >> >> Is there easy (one-step, mouse-only, shortcut or mouse+shortcut) >> way of inserting sum for several sparsely populated (with gaps) >> columns? Like in that _other_ spreadsheet app you select an area >> with values, click "Sum" button on the toolbar and column-wise sums >> are inserted right below the selection. >> >> Thanks a lot. >> WBR, >> K. Palagin. > >Try doing it in the opposite order. Enter the cell where you want the >sum. Click the "Sum" button, then select the area with the values >using the cursor. Click the green checkmark at the top or simply use >the Enter key. > Dan:
Maybe I can explain: You click on the cell you want the sum in. Click on the formula bar and select sum. You hold down the control button and then click (or unclick) the cells you want to sum. Can we do this with OpenOffice.org? James McKenzie --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
