How to specify cell ranges dynamically?
 

Hi, I was wondering how I may do the following?

I have data in several columns. I have calculated a value from these
columns and this sits in a cell, say G5. This value dictates how many
rows I need to sum up in Column H, say. Is there any way that I can put
a formula in a cell which looks something like "=SUM(C <ROW():C
<ROW()+G5)" ?

I.e. sum in column C from the current row to the current row plus the
value in G5?????

Thanks

Dave


--
Agent Wild
------------------------------------------------------------------------
Agent Wild's Profile: http://www.excelforum.com/member.php...o&userid=35163
View this thread: http://www.excelforum.com/showthread...hreadid=549348

How to specify cell ranges dynamically?
 

=SUM(OFFSET(C1,0,0,1,G5))

HTH
--
AP

"Agent Wild" a
écrit dans le message de news:
...

Hi, I was wondering how I may do the following?

I have data in several columns. I have calculated a value from these
columns and this sits in a cell, say G5. This value dictates how many
rows I need to sum up in Column H, say. Is there any way that I can put
a formula in a cell which looks something like "=SUM(C <ROW():C
<ROW()+G5)" ?

I.e. sum in column C from the current row to the current row plus the
value in G5?????

Thanks

Dave


--
Agent Wild
------------------------------------------------------------------------
Agent Wild's Profile:
http://www.excelforum.com/member.php...o&userid=35163
View this thread: http://www.excelforum.com/showthread...hreadid=549348

How to specify cell ranges dynamically?
 

Hi

P.e. for X5
=SUM(OFFSET(C5,G5,0))


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Agent Wild" wrote
in message ...

Hi, I was wondering how I may do the following?

I have data in several columns. I have calculated a value from these
columns and this sits in a cell, say G5. This value dictates how many
rows I need to sum up in Column H, say. Is there any way that I can put
a formula in a cell which looks something like "=SUM(C <ROW():C
<ROW()+G5)" ?

I.e. sum in column C from the current row to the current row plus the
value in G5?????

Thanks

Dave


--
Agent Wild
------------------------------------------------------------------------
Agent Wild's Profile:
http://www.excelforum.com/member.php...o&userid=35163
View this thread: http://www.excelforum.com/showthread...hreadid=549348

How to specify cell ranges dynamically?
 

Thank you for your speedy response! It really is appreciated. It
works, by the way (with the last two paramaters switched).

Thanks again

Dave


--
Agent Wild
------------------------------------------------------------------------
Agent Wild's Profile: http://www.excelforum.com/member.php...o&userid=35163
View this thread: http://www.excelforum.com/showthread...hreadid=549348

How to specify cell ranges dynamically?
 

Hi

One way
=SUM(C1:INDEX(C:C,G5))

--
Regards

Roger Govier


"Agent Wild"
wrote in message
...

Hi, I was wondering how I may do the following?

I have data in several columns. I have calculated a value from these
columns and this sits in a cell, say G5. This value dictates how
many
rows I need to sum up in Column H, say. Is there any way that I can
put
a formula in a cell which looks something like "=SUM(C <ROW():C
<ROW()+G5)" ?

I.e. sum in column C from the current row to the current row plus the
value in G5?????

Thanks

Dave


--
Agent Wild
------------------------------------------------------------------------
Agent Wild's Profile:
http://www.excelforum.com/member.php...o&userid=35163
View this thread:
http://www.excelforum.com/showthread...hreadid=549348

How to specify cell ranges dynamically?
 

Sorry, my mistake here.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )