yogi_Compute Letter GPA Based On Non-Blank Grade Points For Set Of Assignments

Google Spreadsheet   Post  #1976

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug-22-2015

post by  AL:)
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/a-PF2GiyIkE
Arrayformula to Calculate Average
Hello,

I have a spread sheet in which I would to calculate grade point averages (GPA) for classes with a letter grade.  There are 7 periods listed, but some students have only 5 or 6 classes.  GPA should be calculated only for classes with letter grades.

Here's the formula so far.  It does not work:

=ARRAYFORMULA(IF(ROW($A:$A)=1,"GPA",IF(ISNUMBER($AB:AB),AVERAGE(AB:AH),"")))

Link: https://docs.google.com/spreadsheets/d/1shm0GsBPAZAyc2UtDJKupYRpe33-Ec_S9vBw5Sc3Tg0/edit#gid=1799877352

Thanks for reading this post,

AL

---------------------------------------------------------------------------------