i have 35 students . the marks are entered in E5:E37.in E44 i will get the result of a countif formula . it will give the result as how many appeared in the exam. this gives the number appeared. the equation i proposed is something like --- the (sum of (E5:E37/E44)/30*100

E5:E37---where i will enter the marks in a maximum marks of 30. (eg-20 out of 30)
E44 ----where i will get the result of a countif formula which will give the number of students appeared in the examination.

30*100----to find out the average proportionate marks in 100
thanks.