Ross Johnson wrote: > 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? >> > SUMIF() > As I know, the SUMIF-Function compares the values in a range with a certain value and adds all cells of the range that contain this valus. But here there have no special values to be added, but different ranges depending on a special condition.
-- _________________________________________________________________________ Claudia --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
