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

With the cell formatted as percentage, something like this...
=COUNTIF(B1:B12,"Yes")/12

--
Best Regards,

Luke M
"Craig" <(E-Mail Removed)> wrote in message
newsD4967CB-26F5-4DB6-A9DD-(E-Mail Removed)...
> 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

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

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" <(E-Mail Removed)> wrote in message
> newsD4967CB-26F5-4DB6-A9DD-(E-Mail Removed)...
> > 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
>
>
> .
>

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" <(E-Mail Removed)> wrote in message
> > newsD4967CB-26F5-4DB6-A9DD-(E-Mail Removed)...
> > > 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
> >
> >
> > .
> >