Re: summation

On 24 Aug 2001, Gregory Leblanc wrote:

I place the cell cursor at the foot of a column and press the Sigma
sign.  An empty "Sum()" is automatically entered.  OK, but it would be
nice if gnumeric did the Excel thing and offered by default the
summation of the numerical entries above the Summation cell.  But
anyway, I now try to enter the range of the summation manually. I
click on the first cell, and now have, e.g., "Sum(C2)".  I go into the
formula bar and add ":" -> "Sum(C2:)".  Then I click on the last cell,
and get "Sum(C10:)".  Bother -- that's not what I wanted.  That is,
how do I "click in" Sum(C2:C10)?

Try clicking on the first cell that you want (c2), and dragging down to
the last cell that you want (c10).

Why didn't I think of that?  Thanks.

Allin Cottrell.

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]