Formula for calculating a %
 

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?

Formula for calculating a %
 

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?

Formula for calculating a %
 

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



"Mike H" wrote:

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?

Formula for calculating a %
 

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

"Mike H" wrote:

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?