Saturday, August 22, 2015

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),"")))


Thanks for reading this post,

AL
---------------------------------------------------------------------------------