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
|