How to specify cell ranges dynamically?

[Agent Wild]

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

 

[Ardus Petus]

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

HTH

 

[Arvi Laanemets]

Hi

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

 

[Agent Wild]

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

Thanks again

Dave

 

[Roger Govier]

Hi

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

--
Regards

Roger Govier


"Agent Wild" <[email protected]>
wrote in message
news:[email protected]...

 

[Arvi Laanemets]

Sorry, my mistake here.