Re: Please Help! Can't solve excel problem

Discussion in 'Microsoft Excel Misc' started by Don Guillett, Jul 30, 2012.

  1. Don Guillett

    Don Guillett Guest

    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
     
    Don Guillett, Jul 30, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. somaraju

    please solve the problem

    somaraju, Feb 23, 2006, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    137
    flummi
    Feb 23, 2006
  2. Barbara Harris

    Solve this Equation, Please

    Barbara Harris, Feb 23, 2006, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    161
    Bill Martin
    Feb 23, 2006
  3. somaraju

    please solve my pboblem

    somaraju, Mar 30, 2006, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    125
    CaptainQuattro
    Mar 30, 2006
  4. Guest
    Replies:
    1
    Views:
    191
    Rusty
    Sep 17, 2006
  5. Guest

    How to solve a complex problem using Excel 2003

    Guest, Aug 23, 2007, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    1,218
    Guest
    Aug 23, 2007
Loading...

Share This Page