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!