Hi,

Your data layout would have been helpful but it could be as easy as this

=COUNTIF(B2:B13,"0")/COUNTA(A2:A13)

where column A is students and B is practice haour

Mike

"slober" wrote:

Can anyone help me?

I am trying to calculate the % of students playing music practise each week.

I have a column with the amount of practice they have done each week...but I
don't want to calculate the % of practice they have done but the % of
students who HAVE practiced?

How can I do this?