Create a Dropdown list to adjust a cell's formula data range

I'm using the AverageIF formula to look at a range of cells and return an average of those cells in the range that meet a specific criteria.

Is it feasible to extend this functionality by linking the cell/formula to a dropdown menu that could adjust the range in the formula based on the menu selection?

I have attached a spreadsheet as an example.

Ideally, a selection of Week 1, Week 2, or Week 3 would alter the ranges that the formulas look at in the highlighted cells.

Thanks,

Drew