Assuming that the yes answers are in E1:E100, try

=SUMPRODUCT(COUNTIF(INDIRECT("'"&{"Sheet1","Sheet2 ","Sheet3"","Sheet4","Shee
t5"}&"'!E1:E10"),"X"))

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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.