Formula for calculating a %

[slober]

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?

 

[Mike H]

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]

Ok, Mike I think you're on to something..

Basically.... column A is the list of students names...then B is the amount
of hours they have practiced...obviously some are 0.

I want to count the percentage of how many students have practiced... I
tried copying and pasting your formula..but it didn't seem to work? I got an
error message

 

[slober]

Mike. I worked it out! thankyou for your help!

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