This is one is good too! Thanks. WBR, K. Palagin. > -----Original Message----- > From: Barrie Backhurst [mailto:[EMAIL PROTECTED] > Sent: Monday, August 28, 2006 3:09 PM > To: [email protected] > Subject: RE: [users] Calc - summing range depending on parameter > > 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] > >
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
