R1C1 Formula in Excel
I have an RC type formula and I want to dynamically change the end value
based on an entry in A2. I'd prefer to keep IF statements out of it if
possible.
If A2=1, I want it to be
=SUM(RC[9]:RC[9])
If A2=2 I want
=SUM(RC[9]:RC[10])
If A2=3, I want
=SUM(RC[9]:RC[11])
Suggestions?
Thanks,
Barb Reinhardt
|