Calculating Average of Row, user specified end column

[almostnewtoexcel]

Hello

I have a very simple averaging question...

Column A has a list of people.
Column B to Column BA has 52 weekly values for the person in column A.

I want to be able to calculate the average of a person's weekly values for any given week of the year based on a user's input - for argument's sake, cell A1 will contain a number from 1 to 52.

If I enter the number 10 in cell A1, I want to see the average of the first 10 weeks of data for each person.

I have searched high and low for a simple solution, but I'm missing something, Help!

[shg]

Welcome to the forum.

In an unused column starting in row 2, =AVERAGE(B2:INDEX(B2:BA2, $A$1))

[almostnewtoexcel]

A HUGE THANKS!!!!!!!

Cheers