Possible To Average Letters?

I need to average the following row of letters. Is it possible?


A B D C C C C A B D A A A A A = AVERAGE OF THIS ROW (IE B)

If your letters are in A2:P2 and all in upper case try

=CHAR(ROUND(SUMPRODUCT(CODE(A2:P2))/COUNTA(A2:P2),0))

This should work:

=CHAR(ROUND(AVERAGE(IF(A1:Z1<>"",CODE(A1:Z1))),0))

This is an array formula, so once you enter it, hit CTRL + SHIFT + ENTER, rather than just ENTER.

HTH

Jason

Looks like I type too slow. LOL

Hello Jason

faster doesn't always equal better

Your approach copes with blanks whilst mine doesn't

Thank you both for your input. However, i forgot to mention that these cells are retrieving the "Letter Grade" based on another sheet via VLOOKUP command.

So both do not work correctly. But I know you guys will have the answer!

note:
B4:U4 is my range we are dealing with, btw.

Originally Posted by couger77

Thank you both for your input. However, i forgot to mention that these cells are retrieving the "Letter Grade" based on another sheet via VLOOKUP command

That shouldn't make any difference unless some of the cells return #N/A, is that the case? If not what results did you get with the above suggestions?

What are the possible results in B4:U4?

#VALUE! is what I am getting for a return in cell V4.

The range of letters is simply A,B, or C.

It is possible there might be an #N/A (will fix later) or blank in any given cell.

Cheers