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

6   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