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   Aug-22-2015
post by  AL:)!category-topic/docs/spreadsheets/a-PF2GiyIkE
Arrayformula to Calculate Average

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:


Thanks for reading this post,