hiya guys and gals

I have a big problem. I need to make a spreadsheet for work. i'll try to explain as best as i can.

Cells A6 to A64 contain the numbers 1 to 52, these represent the weeks of the year. In cells B6 to B64 any hours that a staff member has been off will be recorded. Cell C1 contains a member of staffs contracted hours. Cell D1 contains the current week number. Cell E1 need to count how many hours (from B6 to B64) were off, but only the last 26 weeks. For example if the current week is 30 it would need to calculate from wk 4 to wk 30 but if the current wk is week 5 it would need to add week 1 to wk 5 and wk 31 to wk 52.

I have tried loads of ways of doing this and just end up confusing myself to the point of suicide!

I need HELP!!!!!!!!!!!!!!

Please to the sake of my blood pressure, help me find a solution!

Regards

James