Forum Discussion
Pinkelephants2020
Oct 22, 2020Copper Contributor
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...
devyadav2008
Dec 03, 2020Brass Contributor
=+SUMPRODUCT((B2:H2=K8:K19)*L8:L19)