| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is Formula not calculating? | Excel Discussion (Misc queries) | |||
| Entering a Formula; Remains a Formula Instead of Calculating | Excel Discussion (Misc queries) | |||
| formula for calculating different % | Excel Discussion (Misc queries) | |||
| where is the formula for calculating the APR | Excel Discussion (Misc queries) | |||
| Formula for calculating age | Excel Discussion (Misc queries) | |||
Linear Mode
