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
...
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
.
|