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()
There is also a COUNTIF() function.
Ross
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
