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)

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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