Bit late but here's an alternative
=SUM(INDIRECT("A2:" & ADDRESS(2;A1)))
Barrie
On Mon, 2006-08-28 at 13:53 +0400, Kirill S. Palagin wrote:
> YYYYEEEEESSSS!!!! This is it!!!
> Thank you!
> Thank you for both pointer to function and working example - Help topic
> is not easy to understand!
>
>
> Ross, arnold, Claudia
> thanks for your ideas!
>
> WBR,
> K. Palagin.
>
>
> > -----Original Message-----
> > From: Terry [mailto:[EMAIL PROTECTED]
> > Sent: Monday, August 28, 2006 12:59 PM
> > To: [email protected]
> > Subject: Re: [users] Calc - summing range depending on parameter
> >
> > Try this: =SUM(OFFSET(A1;1;0;1;$A$1))
> >
> > Kirill S. Palagin wrote:
> > > Hello.
> > >
> > > I need to sum the range of cells with the range itself depending on
> > > parameter, that is if $A$1 is 1, then Sum(A2:A2), if $A$1
> > is 2, then
> > > Sum(A2:B2), if $A$1 is 3, then Sum(A2:C2), etc.
> > > So far I see very inelegant solution involving IF with each
> > item to be
> > > summed.
> > > Is there a better way?
> > >
> > > Thanks a lot.
> > > WBR,
> > > K. Palagin.
> > >
> > >
> > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: [EMAIL PROTECTED] For
> > > additional commands, e-mail: [EMAIL PROTECTED]
> > >
> > >
> > Send instant messages to your online friends
> > http://au.messenger.yahoo.com
> >
> > ---------------------------------------------------------------------
> > 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]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
