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...
In I2:
=SUMPRODUCT($L$8:$L$19*(B2:H2=$K$8:$K$19))/COUNTA(B2:H2)
This can be filled down.
Hi Hans, This didn't seem to work. Perhaps I didn't explain myself though. I tried an array formula in the total column to average out the scores given to John, so B2 to H2 with the average showing in I2. This only works if you have letters not an A+ or B-, it wont recognise the minus or plus symbols.
I then thought I could create a list and give each letter a score/number and use this to create a formula. That is as far as I got as I don't know how to use the list to create the formula I need.
Thanks for helping me though. I am still trying 🙂
