dropdown list to select start and end of average range

Hi all,

I need to create a function that will allow an input for a start and an end range for multiple average calculations.
The function needs to apply to all items in Column A.

In the example, I have the average for all items for all weeks.
But if I wanted to see the average for all items between weeks 47 and 50, I would select the start and end and then the average figures would update for all items to that range.

Hope that makes sense?

Thanks

You can use this formula (e.g. in T2):

=AVERAGE(INDEX(B2:P2,MATCH($U$2,$B$1:$P$1,0)):INDEX(B2:P2,MATCH($V$2,$B$1:$P$1,0)))

then copy down.

Hope this helps.

Pete

Thanks Pete, works exactly as needed! added rep.

Glad to help, Neil - thanks for the feedback.

Pete