I have 30 colleagues who are answering questions over 3 time periods. Each has their own Excel workbook with the questions, and over the year they update it. I collate their worksheets into one master worksheet, but now need to combine their answers into a simple table. The questions, the time periods and then a COUNT of how many answered it.

For example: I need a table that shows me how many people (not the persons name at this point) answered question 10 in time period 2.

I can't use a database before someone mentions it ;).

Many thanks

Mike.