If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Count Text to get a Percentage
Hi,
I have 12 offices and each needs to do a reporting exercise. Part of that exercise is to enter a Yes or No into a column - example would be: 'Have you carried out a H&S Check?' - Validation List = Yes or No From that answer I need to get a % of the 12 that answer Yes and a % of those that answer No - the results will be displayed in seperate colunms on a Master Tracker Sheet I have - hope that makes sense Is there a function for this? regards Craig |
#2
|
|||
|
|||
Count Text to get a Percentage
With the cell formatted as percentage, something like this...
=COUNTIF(B1:B12,"Yes")/12 -- Best Regards, Luke M "Craig" wrote in message news Hi, I have 12 offices and each needs to do a reporting exercise. Part of that exercise is to enter a Yes or No into a column - example would be: 'Have you carried out a H&S Check?' - Validation List = Yes or No From that answer I need to get a % of the 12 that answer Yes and a % of those that answer No - the results will be displayed in seperate colunms on a Master Tracker Sheet I have - hope that makes sense Is there a function for this? regards Craig |
#3
|
|||
|
|||
Count Text to get a Percentage
Assuming that your Yes/No responses are in F2:F13, then:
=COUNTIF(F2:F13,"yes")/12 and for the no percentage, either =COUNTIF(F2:F13,"no")/12 or, assuming the yes percentage is in G2: =1-G2 Those will give you a decimal number, format as percentage to see them expressed as a percentage. "Craig" wrote: Hi, I have 12 offices and each needs to do a reporting exercise. Part of that exercise is to enter a Yes or No into a column - example would be: 'Have you carried out a H&S Check?' - Validation List = Yes or No From that answer I need to get a % of the 12 that answer Yes and a % of those that answer No - the results will be displayed in seperate colunms on a Master Tracker Sheet I have - hope that makes sense Is there a function for this? regards Craig |
#4
|
|||
|
|||
Count Text to get a Percentage
Thank you Luke M and JLatham......Both methods work
My boss has more functions for me to sort - some of which I will need help on - your speedy and accuate response and assistance makes this soo much easier Excellent, Thanks Craig "Luke M" wrote: With the cell formatted as percentage, something like this... =COUNTIF(B1:B12,"Yes")/12 -- Best Regards, Luke M "Craig" wrote in message news Hi, I have 12 offices and each needs to do a reporting exercise. Part of that exercise is to enter a Yes or No into a column - example would be: 'Have you carried out a H&S Check?' - Validation List = Yes or No From that answer I need to get a % of the 12 that answer Yes and a % of those that answer No - the results will be displayed in seperate colunms on a Master Tracker Sheet I have - hope that makes sense Is there a function for this? regards Craig . |
#5
|
|||
|
|||
Count Text to get a Percentage
Apologies, they arent 'both methods' but I've got it thanks....
"Craig" wrote: Thank you Luke M and JLatham......Both methods work My boss has more functions for me to sort - some of which I will need help on - your speedy and accuate response and assistance makes this soo much easier Excellent, Thanks Craig "Luke M" wrote: With the cell formatted as percentage, something like this... =COUNTIF(B1:B12,"Yes")/12 -- Best Regards, Luke M "Craig" wrote in message news Hi, I have 12 offices and each needs to do a reporting exercise. Part of that exercise is to enter a Yes or No into a column - example would be: 'Have you carried out a H&S Check?' - Validation List = Yes or No From that answer I need to get a % of the 12 that answer Yes and a % of those that answer No - the results will be displayed in seperate colunms on a Master Tracker Sheet I have - hope that makes sense Is there a function for this? regards Craig . |
Thread Tools | |
Display Modes | |
|
|