Claudia Drechsle wrote:
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.
Yes, you're right. I misread the question.
Ross
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
