Forum Discussion

Pinkelephants2020's avatar
Pinkelephants2020
Copper Contributor
Oct 22, 2020

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...
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Oct 22, 2020
for Excel 2016 formula =CHAR(CEILING(SUMPRODUCT(--(CODE(UPPER(B2:H2))))/COUNTA(B2:H2);1))
  • devyadav2008's avatar
    devyadav2008
    Brass Contributor
    Dec 03, 2020
    Auto correction option path is

    go to file-option-proofing-Auto Correct Option
  • devyadav2008's avatar
    devyadav2008
    Brass Contributor
    Dec 03, 2020
    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.

Resources