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

=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

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

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

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

Sorry, my mistake here.


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