Sorry for any repetition with previous questions but I am completely hopeless
with excel functions and got lost when attempting to use functions contained
within previous postings.

My problem: I have a questionnaire for 27 sites. For each site I have the
completed questionnaire entered into a seperate worksheet i.e 27 worksheets.
The answer for each question is "Y", "N", "NK", or "NA". I need to provide a
summary of the 27 sites which I want to enter on a blank master questionnaire
on a seperate sheet. Can anyone help with a formula that counts the number of
"Y", etc for each question (the cell for each question is the same for each
site on the different sheets). If possible, can the summary cell indicate the
number of Y's, the number of N's, the number of NK's, and the number of
NA's?? It would also be fantastic to produce the results for each Y, N, NK,
and NA as a %.

Each questionnaire contains approx 200 questions so I would like to be able
to paste the formula into each result cell on the summary sheet.

Any assistance gratefully received!