Hi ss

I would use the countif function explained in the help and referencing the employee spreadsheets. It would look something like this =countif('path[workbook.xls]sheet1'!a1:a25,"yes"
=countif('path[workbook.xls]sheet1'!a1:a25,"no")
That would give you the count of yes and nos for an empolyee. Then repeat for each empolyee changing the workbook. When you open the worksheet you'll be prompted to update the links. All of you summarization will be done when you update

Mike