Tracking survey data
I have seven workbooks, each with the same survey worksheet, that will be
filled out by different people.
The values that can appear in column E, from rows 3 through 12, can be 0
through 5. I need the total count of each value from all of the worksheets
to display in a "master" sheet. Something that looks like this (which will
probably get horribly mangled when uploaded):
Question 0 1 2 3 4 5
1 0 4 1 2 0
0
2 0 0 3 2 1
0
I'm looking for hints as to how to get started. I'm just not sure which
Excel functions to look use. CountIf seems to be a possibility, but I don't
see a way to use it across workbooks. If I have to copy all the worksheets
into one document to make it easier, I will.
Thanks, in advance, for any advice.
Larry
|