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.

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

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

"Dave O" wrote:

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

=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


"midwestern" wrote in message
...
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.

"midwestern" wrote in message
...
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