gradebook average

[Guest]

How do I average these grades that are in columns across. Here are the
grades... 42/50, 20/30, 25/25, 13/15, and 87/100. These are in cells B2 thru
F2. Please respond ASAP! Thanks.

 

[Dave O]

Are these entered as 42/50, or formulas- say, =42/50?

 

[Guest]

They are entered as 42/50..like a grade, the student got 42 out of 50 on an
assignment.

 

[N Harkawat]

=SUMPRODUCT(--(LEFT(B1:F1,SEARCH("/",B1:F1)-1)*100),--(1/RIGHT(B1:F1,(LEN(B1:F1)-SEARCH("/",B1:F1)))))/COUNTA(B1:F1)

And using your example I got an average of 84.86 out of 100

 

[Fredrik Wahlgren]

They are entered as 42/50..like a grade, the student got 42 out of 50 on an
assignment.

The problem is that you need to evaluate 42/50 as as 0.84 before you can
calculate the average. Here's how you do that.

1) Select Tools|Macro|Visual Basic Editor
2) Insert a new module
3) Copy and paste this code into the module

Public Function Eval(ByVal s As String) As Variant
Eval = Application.Evaluate(s)
End Function

Now, if cell A1 holds the string 42/50, you can enter =Eval(A1) in a
different cell and it will return 0.84
Insert this newly created function in a different column and apply the
Average function
http://www.techonthenet.com/excel/formulas/average.htm

/Fredrik