I have a sheet that has columns of data - with the date in the first column
and a value in the second column. Data is entered for each day.

On a seperate sheet I want to summarise this data to give a weekly total,
preferably by locating a date on the first sheet and then adding the value
for this day to the six values above.

Have looked at using LOOKUP and OFFSET, but I'm sure there's an easier way?