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.
As I see you must define each item. You could use a different formula, but I don't think, it would be "better": =SUM(A2:C2)*(A1=3)+SUM(A2:B2)*(A1=2)+A2*(A1=1) -- _________________________________________________________________________ Claudia --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
