One way:

=(COUNTIF(A1:Z1,"A")*4+COUNTIF(A1:Z1,"B")*3+COUNTI F(A1:Z1,"C")*2
+COUNTIF(A1:Z1,"D"))/COUNTA(A1:Z1)

In article ,
"Will in SF" <Will in wrote:

Hi.

I need a formula that averages grades with the following values...
A=4,B=3,C=2,D=1,F=0. I am entering the actual letter grades in the cell.