Monday, January 7, 2013

yogi_Compute Average Score Row By Row Of Student By Test Number


                                          Google Spreadsheet   Post  #961
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 07, 2013
user edj2010 said:(http://productforums.google.com/forum/?zx=uvm2h07tjqsa#!category-topic/docs/spreadsheets/afD94Abyhq0)
complex lookup help needed
I am making a gradebook program that handles large classes over multiple semesters. I need a way to look up the titles of columns and use that to make an average for each term. example:

         A             B          C          D          E          F          G
1   student id    T1         T1         T2         T3        T3         T3
2   2222           95         90         100       65        70          71
3   3333           98         89         100       50        71          75
4   4444           85         96         90         44        70          90
5   5555           68         0           95         72        79          91
  6666           99         77         99         94        76          10
7
8 Type Id for grades:
9                     T1         T2         T3
10 6666           88         99         60
11 or           avg(99,77) avg(99) avg(94,76,10)\

please help i have looked everywhere but simply cant find a solution.
thanks in advance.
-------------------------------------------------------------------------------------

following is a solution to the problem ... a single array formula for all the students and the tests in the table A1:G6