=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