Do you want the average *letter* grade? What are the possible letter grades?
What average would you expect from C, A, D ? What average would you expect
from A, B ?

Biff

"Param" wrote in message
...
I have grades that (link from diferrent worksheets)
e.g.

A1: C
A2: A
A3: D
A4: #DIV/0! (because no input at that particular worksheet)
A5: #DIV/0! (because no input at that particular worksheet)

Formula I used as below:

ARRAY FORMULA*
A6: =AVERAGE(IF(A1:A50,A1:A5))

the return answer is #div/0!

how to modify this formula to cater for grades.