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

user brianteacher said: (!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.

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