Forum Discussion
Formula to average Letter grades
Hi All, I am not an expert in excel but I a, trying work out how I can calculate an average of grades. There are 7 questions each scored with a grade and then I need to average the scores. I add...
for Excel 2016 formula =CHAR(CEILING(SUMPRODUCT(--(CODE(UPPER(B2:H2))))/COUNTA(B2:H2);1))
you can do this without any formula also..
once you create auto proofing like whenever you write any grade it will be convert in score than you can sum.
once you create auto proofing like whenever you write any grade it will be convert in score than you can sum.