What is the formula to average alpha?

[Guest]

I have a spreadsheet I'd like to enter alpha which represents numbers and
have that row average itself. Any formula ideas?

 

[Bernard Liengme]

Here is one that works with A, B, C and D;
=SUMPRODUCT(LOOKUP(D8:F8,{"A","B","C","D"},{4,3,2,1}))/COUNTA(D8:F8)
best wishes

 

[Bernard Liengme]

You need to have every possible alpha character. SO if this if for a GPA
=SUMPRODUCT(LOOKUP(D8:F8,{"A","B","C","D","F"},{4,3,2,1,0}))/COUNTA(D8:F8)

 

[Guest]

I've typed in the formula exactly as you have it and I still cannot get it to
work. Any suggestions?