the dropdowns aren't hurting anything. you can use the SUMIF function
to do this (if your weeks are separated) or SUMPRODUCT function (if
all your times for all your weeks are together in one big list). Tell
us what data is in what rows and columns and we can give you the
function.