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