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

[riceguy]

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

[Ace_XL]

Try AverageIfs

=AVERAGEIFS($D$7:$D$54,$A$7:$A$54,$B$3,$C$7:$C$54,"Shift 1")

Change Shift accordingly or reference it to a separate cell

[riceguy]

Thanks Ace_XL!

Works like a charm.

Attached is the completed worksheet.