Sum values from table based on list returned from array

[TFiske]

I have an array formula that returns a list of areas scheduled for service for a given week number. I need a formula to evaluate that list against a table that provides man-hours per area, acres per area, etc and sums these values for that week. Currently I am using several large arrays that do this already but I need a more efficient method. I have tried combinations of SUMIF, INDEX/MATCH and OFFSET but the formulas will only evaluate the first area on the list and not the entire array for that week. I've attached a simplified spreadsheet for reference, thanks: