PC Review


Reply
Thread Tools Rate Thread

Re: Please Help! Can't solve excel problem

 
 
Don Guillett
Guest
Posts: n/a
 
      30th Jul 2012
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help! Anyone! Please Please Please Please Please Please =?Utf-8?B?UmFuZHk=?= Microsoft Access Macros 2 17th May 2004 07:16 PM
Please help solve these mysteries (Excel columns, etc.) D Warcken Microsoft Excel Discussion 3 26th Dec 2003 05:36 AM
Multidimensional Array problem I can't solve ! Please help me out ! David Van Heuverswyn Microsoft Excel Programming 3 6th Oct 2003 01:49 PM
Please solve this Asus A7v8x-x Motherboard Problem Jon Windows XP Hardware 7 30th Sep 2003 12:20 PM
these URLs helped me solve my bridging problem...hope it can helps someone else and save the 3 days it took me to solve kenw Windows XP Networking 0 25th Jul 2003 06:21 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:41 PM.