There may be an easier way, but this will work.

=(COUNTIF(Sheet1!A:A,"x")+(COUNTIF(Sheet2!A:A,"x") +(COUNTIF(Sheet3!A:A,"x")+(COUNTIF(Sheet4!A:A,"x") +(COUNTIF(Sheet5!A:A,"x"))))))

A:A is your yes column.

HTH,
Paul

"MCK" wrote in message
...
I am trying to automate ta summary page of a quesionnaire process. The
questionnaire contains 6 worksheets. 5 of them are the questionnaires and
the 6th is the summary sheet. On the questionnaires there are 3 columns:
yes, no and n/a. On the summary sheet I need to count the values in the
yes
column and turn that into a percentage. The value placed in the field is
an
"X", and the top score would be 100% (5/5).

At this point I am trying just to count the X's in the yes column. I am
trying to use countif and listing the range as the cell in each worksheet,
separated by a comma, then "X". It is not working and gives me an error -
can't figure out why, nor how to fix it.

Does anyone have any suggestions? Thanks in advance for your help.