Average of weighted letter grade.

Hi guys,

I am working on an evaluation sheet in excel 2010. Which looks as following:

Criteria Weighfactor Score (A/B/C/D) Weighted score
1.Housekeeping 40% A ...
2.QHSE 20%
3. ...
4. ...
5. ...
6. ...
7. ...
8. ...

Every criteria has a weight factor which is a number. The rating that the evaluator is giving the criteria is a letter grade.
I do have the formula to calculate the average of all letters which is

=CHAR(INT(SUM(IF(E25:E78<>"",CODE(E25:E78))/COUNTA(E25:E78))))

Does anybody have an idea how to implement the weight factor (for example 40%) to the letter grade so at the end at the right average is calculated.

Thanks for your help,

Nico

Try

=LOOKUP(B4,{0,0.1,0.2,0.3},{"D","C","B","A"})

and adjust the boundaries to suit

Thanks! works like a charm