Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inputing survey data | Excel Discussion (Misc queries) | |||
Pivot Table of Survey Data | Excel Worksheet Functions | |||
Gathering Survey data | Excel Discussion (Misc queries) | |||
summerize survey data | Excel Discussion (Misc queries) | |||
tabulating and analyzing survey data | Excel Discussion (Misc queries) |