Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #695 Aug 14, 2012 www.energyefficientbuild.com.
user B-House said: (http://productforums.google.com/forum/?zx=76albpq7qu02#!category-topic/docs/spreadsheets/_2mcpQHtUOU%5B1-25%5D)
Excluding Text when using ArrayFormula for Average in Spreadsheet
I am trying to create a google form to track a student's GPA. We have 4 classes and I used this formula
following is a solution to the problem