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

"Bernard Liengme" wrote:

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 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?