Re: Please Help! Can't solve excel problem

On Sunday, July 29, 2012 10:27:33 PM UTC-5, sully017 wrote:
> I've dabbled in excel over the years but have hit a cross roads. I help
>
> teach a middle school track summer camp. Now every week we do certain
>
> timed activities and keep track of the results. Here is the problem- I
>
> can't find a way to average these results.
>
>
>
> My excel sheet is set up with 5 sheets. Sheets 1-4 Being labeled Week1,
>
> Week2, Week3, Week4 and sheet 5 is for my calculations. Each sheet is
>
> set up identical with students name in column A (i.e. John, Tim, Sarah,
>
> Connie) and the timed events in the remaining columns (ex. 100m, 200m, 3
>
> cone drill, etc, etc)
>
>
>
> Now I would like to have a master sheet that will tell me Johns (and
>
> every other students) average time for each event across the 4 week
>
> period. (i.e. average time for 100m, 200m, 3 cone drill, etc) The
>
> problem i seem to be running into is that John is not always in cell A1
>
> one week he will be in cell A1 the next week he will be in cell A19.
>
>
>
> Any help would be appreciated.
>
>
>
>
>
>
>
>
>
> --
>
> sully017

You should always provide a meaningful subject line. If desired send file to dguillett1 @gmail.com with complete details