how to get the subject average of a class?

[sumesh56]

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.

[newdoverman]

In E44 enter

=SUM(E5:E39) (35 Possible scores for the students if everyone took the test) Missing tests of course are not summed.

Enter this where you want the count of the students that actually took the exam.

=COUNTA(E5:E39)

If you simply want the average score for those taking the class to be a percentage use this where you want the answer

=(AVERAGE(E5:E39)/30)*100

[sumesh56]

In E44 enter

=SUM(E5:E39) (35 Possible scores for the students if everyone took the test) Missing tests of course are not summed.

Enter this where you want the count of the students that actually took the exam.

=COUNTA(E5:E39)

If you simply want the average score for those taking the class to be a percentage use this where you want the answer

=(AVERAGE(E5:E39)/30)*100

thanks a lot for the suggestion. this is what i wanted. have a nice day.

[newdoverman]

You're welcome. Glad to help.