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

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?

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?

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?