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