Hi Dana

Very neat solution!!
I had been playing about with
{=AVERAGE(69-CODE(J1:J5))}
but the lack of "E" in the range of Grades being used gave me the wrong
results, as "F ended up as a -1.

I can't work out how you came up with the 2530 to use as the dividend in
the formula?

Regards

Roger Govier



Dana DeLouis wrote:

If you use Data | Validation to ensure that you only have A,B,C,D or F (& no
blanks), then perhaps this Array formula...

=AVERAGE(MOD(2530,CODE(A1:A5)-59))

HTH :)