Array or countifs for counting survey responses

Originally Posted by randell.graybill

Looking at your data, but how do you come up with 15 for country 1, what range is counted to come up with 15? same for country 2?

Counting horizontally I come up with 8 for country 1 and 4 for country 2, can't see how you could come up with 15 and 5.

Each RECORD 1, 2, 3, 4, 5 etc is a VERTICAL record of each question. So by starting at record 1 and working VERTICALLY down....we see an x in the country and under that x other x's. I am counting the ANSWERS or the X's in the verticle ANSWERS column for EACH x found as representing the countries column.


basically if that was too confusing...wherever there is an x in country1 or country 2, im counting and adding up all the x's UNDER (or vertically) in the answers column.

THANKS SO MUCH FOR YOUR HELP. If i can get this figured out it will save TONS of hours....

based on how simple the data is you have entered then the follow formula will work

Please Login or Register  to view this content.

its not elegant but it worked for the sample set of data you gave.

any one else have any knowledge in how to get this working? i could really use your guys EXPERTISE. Looking forward to the solution.

thanks

again not the tidiest solution but look over what it does, if the concept is correct then I'm sure someone else here on the forums can make this thing work more cleanly. I have only recently started actually writing my own code and still am far from expect. But the below code will tell you the same thing as the formula I gave you. And with modification I'm sure can intelligent figure out the rest...but that is the part where I can't go any further.

To test this out just click on an empty cell on the sample sheet you gave me and it will give you the answer you seek.

Please Login or Register  to view this content.

I am tallying the responses from 100's of surveys. I would like to analyze the data by selecting a conditional response from Question1, and then tally the corresponding responses given in Question2. I have attached a simple Excel example. Remember, there are 100's of surveys (records). How do I write a formula that can be easily repeated?

Thanks for this simple solution! I had not thought of this approach. You guys are great! This will get me going again.