> -----Original Message----- > From: Dan Lewis [mailto:[EMAIL PROTECTED] > Sent: Monday, October 23, 2006 11:21 PM > To: [email protected] > Subject: Re: [users] Calc, _easily_ summing sparsely > populated columns?
> > 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 That works if I need to sum just one column, but I am talking about several columns at once. In this case it either does not work or I am doing something wrong. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
