Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
R1C1 Formula in Excel
0 views
Skip to first unread message
Barb Reinhardt
Dec 8, 2005, 9:16:02 AM12/8/05
to
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.
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
bpeltzer
Dec 8, 2005, 9:26:04 AM12/8/05
to
Try =SUM(OFFSET(RC[9],0,0,1,R1C2)). The offset basically defines a range
that begins at RC[9], taking one row and R1C2 columns.
that begins at RC[9], taking one row and R1C2 columns.
Sloth
Dec 8, 2005, 9:40:05 AM12/8/05
to
you can use the INDIRECT function which turns a text string into a reference.
=SUM(INDIRECT("RC[9]:RC["&8+A2&"]"))
=SUM(INDIRECT("RC[9]:RC["&8+A2&"]"))
0 new messages