Average Function Limited to the Number of Students

Hi Everybody,

I am working on an excel master marksheet which will be distributed to many teachers to fill in their students marks. How can I enter an average function that can work out the mean for those different classes. For example I'd like the main average function to be like this =average(d5:d50) but if a teacher has thirty students in his list the mean will be only limited to the marks of those thirty students. Same thing I want for the mode function and the median function.

Thanks in advance.

Alya

Thanks a lot for your help. this is a sample file. Please help

Thanks a lot Canapone.

What about the mode function?

Why Don't you use just =sum(d5:d50)/count(d5:d50)

Thank you so much Vugar and Canapone for your suggestions which were really helpful.