Saturday, September 29, 2012

yogi_Compute Frequency Of Grades By Possible Grade List

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #785  Sep 29, 2012    www.energyefficientbuild.com.

user brianteacher said: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/u9N4V0H8uFo)
Grade distribution

I found an old thread with a great spreadsheet example by ahab that shows a formula for counting the distribution of letter grades.

https://groups.google.com/d/topic/How-to-Documents/vvhEWGD2UCM/discussion

I was wondering if there would be a way to adapt such a formula to return "0" if there are no (for example) "D" grades.
------------------------------------------------------------------------------------------------
following is a solution to the problem