What is the formula to average alpha?
 

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

What is the formula to average alpha?
 

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?

What is the formula to average alpha?
 

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?

What is the formula to average alpha?
 

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?