Tracking multiple Survey Responses with Countif

hi bill,

you can use consolidate in data/consolidate, use count in the function cell, select the cells in each sheet in the reference part and select use labels in left column, as long as the target cells are the same on each sheet it will add up the numbers accordingly.

i have attached an example file, hope it helps

thanks reg

I dont think consolidate is going to work. I tried with the count function and all it did was count the cells from the spreadsheets. I am sending an attachment with one example of a returned survey. We have 85 salesmen and they all returned surveys in the same format. I need to count how many 1's were listed for the first issue, how many 2's, how many 3's, all the way up to how many 15's for issue number one. I have 15 issues I need to count in this way. The survey is meant to get an idea of how important the 15 issues are to each salesperson. They had to rank each of the 15 issues from 1 to 15. I need to count how many of each number was assaigned to each issue.
I hope this helps. If you have another suggestion I am up for it.
Thanks.

Here is the link for the sample Excel Survey sheet.