Need help with complex Lookup formula....

[vpr80]

Need a formula that I just can't seem to get.

I have a sheet that has a header row "Day 1" to "Day 31" then belo
that a section of rows with data.

Day 1 Day 2 Day 3 Day 4 ........
1 0 -1 2 ........
0 3 -10 5 ........

What I need to do is write a lookup that takes a day number input (Fo
example, 2) and adds all the data from the column that has "Day 2
header to the next 7 days to "Day 9". So it would be 7 coulmns wide an
like 20 rows down.

I've tried all sorts of stuff but HLOOKUP only returns one cell once i
gets the right column.....how do I get it to sum a block???

I tried everything from lookups to match to indirect and I can't see
to figure this bitch out....thanks!!

 

[Frank Kabel]

Hi
if your dates start in column A try the following (X1 stores your input
value, e.g. 2):
=SUM(OFFSET($A$2,0,X1-1,100,7))