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

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

HTH
--
AP

"Agent Wild" <[email protected]> a
écrit dans le message de news:
[email protected]...
>
> 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<at>tarkon.ee )


"Agent Wild" <[email protected]> wrote
in message news:[email protected]...
>
> 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<at>tarkon.ee )


"Agent Wild" <[email protected]> wrote
in message news:[email protected]...
>
> 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

Hi

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

--
Regards

Roger Govier


"Agent Wild" <[email protected]>
wrote in message
news:[email protected]...
>
> 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<at>tarkon.ee )