Excel: What formula combines this data into one COUNT amount?
- by Mike
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.