What is the formula to average alpha?

N

Ninibelle

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

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
 
B

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)
 
N

Ninibelle

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