I have a spread sheet and on it I have a date range that is different per row.
So row 1 may be Sept 09 to May 10, row two may may June 09 to July 10.

I also have a value of hours that I want to allocate to each of these
periods of time ie. row 1 may be 3 hours per week, row 2 could be 5 hours
per week and so on...

Is there any way that I can get excel to automatically format the cells
across the date range so that I can total up per period how many hours are
allocated? And it needs to look something like this...Currently I have to
manually input each line.

June July Aug Sept Nov Dec Jan Feb Mar Apr May Jun July
3 3 3 3 3 3 3 3

5 5 5 5 5 5 5 5 5 5 5 5 5

Thanks!